Export to excel in asp.net using excel template

Grey

i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only and
some column should be highlighted. the format cells are fixed. is there any
way to excel the data set to pre-defined excel sheet.

Oct 16 '07 #1

Subscribe Post Reply

3718

Alvin Bruney [MVP]

Export to excel doesn't expose that type of functionality programmatically.
You may want to look at a 3rd party or Excel library.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99
"Grey" <kj@jk.comwrote in message
news:OP**************@TK2MSFTNGP05.phx.gbl...

>i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only and
some column should be highlighted. the format cells are fixed. is there any
way to excel the data set to pre-defined excel sheet.

Oct 17 '07 #2

Mark Rae [MVP]

"Grey" <kj@jk.comwrote in message
news:OP**************@TK2MSFTNGP05.phx.gbl...

i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only and
some column should be highlighted. the format cells are fixed. is there
any way to excel the data set to pre-defined excel sheet.

http://www.aspose.com/Products/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 17 '07 #3

carion1

http://www.microsoft.com/downloads/d...displaylang=en

On Oct 16, 10:23 am, "Grey" <k...@jk.comwrote:

i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only and
some column should be highlighted. the format cells are fixed. is there any
way to excel the data set to pre-defined excel sheet.

Oct 17 '07 #4

Mark Rae [MVP]

"carion1" <dd******@gmail.comwrote in message
news:11**********************@v23g2000prn.googlegr oups.com...

http://www.microsoft.com/downloads/d...displaylang=en

On Oct 16, 10:23 am, "Grey" <k...@jk.comwrote:
>i need to export the data set to excel in asp.net, but my requirement is
need to use the template, i.e. some column should be lock as read-only
and
some column should be highlighted. the format cells are fixed. is there
any
way to excel the data set to pre-defined excel sheet.

Ignore this - it is for WinForms.

Server-side Office automation is not supported by Microsoft because it
doesn't work:
http://support.microsoft.com/default...US;q257757#kb2
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Oct 17 '07 #5

by: Steven Stewart | last post by:

I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...

Microsoft Access / VBA

Export to Excel

by: jeffgeorge | last post by:

I'm currently exporting a form to Excel. Because there are controls and totals in the header, I first have a button for users to convert to a datasheet. Then I use the automated quick office...

Microsoft Access / VBA

Reading records into Crystal Report for export as Excel?

by: Robin Cushman | last post by:

Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...

Microsoft Access / VBA

Export to Excel multiple existing sheets

by: sunilkeswani | last post by:

I need help with exporting data from 2 access tables, into 2 existing spreadsheets in a single Excel file. Currently, I am using this code: DoCmd.TransferSpreadsheet acExport, 8, "Table1",...

Microsoft Access / VBA

button to export to excel

by: DC Gringo | last post by:

I have a simple button that should open another window and export a datagrid to an Excel file. I'm getting: "Name 'window' is not declared." What do I need to declare or import? <INPUT...

ASP.NET

Single Quote Problem in Excel to Export

by: Prasad Dannani | last post by:

Hi, We have to export our data in sql server table to any excel sheet. We have a template to export, using oledb we are inserting rows to this template and generating the excel output. The...

ASP.NET

Excel export from template

by: RobinAG | last post by:

Hello, I'm trying to create a new Excel document from a template I've created (Export.xls). I'm having trouble getting it to work, sometimes it works, sometimes it gives me a run-time error '70',...

Microsoft Access / VBA

Export Access query to Excel using a command button on an Access form

by: CoolFactor | last post by:

MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am...

Microsoft Access / VBA

Export to excel mutiple sheet

by: hemantbasva | last post by:

Note We need to have a template on server for generating report in multiple sheet as we do not had msoffice on server moreover this require a batch job to delete excel file created by the...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Export to excel in asp.net using excel template

Similar topics