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.
|
|
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.
|
|