Re: Create Excel using asp.net

K

Kyril Magnos

Hello Lina,

Excel files can be created by creating comma or tab deliminated files and
then pushing those to the client. When most people install Office, Excel is
setup as the default application to open .CSV or .tab files and import them.
That is by far the easiest solution.

The other solution would be to copy over the OfficeXP or Office2003 interop
DLLs to the server and then use the Excel object to create and save your
files.

It all really depends on what you want to create within the Excel file. If
you are looking to just port a datagrid or a datatable, then I would say
that the CSV file is the way to go. If you are looking for more advanced
features such as ranges and workbook creation and such, then using the Excel
object is the way to go.

This is an article on how to export a datagird to a CSV file.
http://www.netomatix.com/GridExportToCSV.aspx

--
HTH

Kyril Magnos

Question of the day:
What is Mono?
A) Disease where the lymph nodes become swollen.
B) A single sound
C) A synonym for one
D) A port of .NET meant to royally irritate MSFT
E) All of the above.

|I would like to know how to create an Excel file using asp.net in the
server and send it to user local machine thru IE.
| The problem is the fact that the server don't have the Excel installed.
|
|
 
G

Guest

Thx Kyril,

In fact, I need to produce a well formatted excel worksheet, with specified font, color, etc.. I think I can't just produce it in .csv format. is there any example for using OfficeXP or Office2003 interop DLLs Excel object for this purpose?

Lina
 
A

Alvin Bruney [MVP]

have a look at the office web component toolpack, it should guide you thru
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top