Write Excel file under FileSystem in ASP.NET 1.1

Question

Hi,

I would like to write an excel file under file system. The data source for the excel file will come from SQL Server 2000 in the form of DataSet/DataTable. COM InterOp is not allowed to use in my workplace. The users are using various excel version; 97 - 2003.

It's pretty urgent and it would be much appreciated if you come out possible solutions.

Regards, Thurein

Answer 1

Write tab delimited data to a text file, save with ".xls " extension. Excel should be able to read that.

Answer 2

If you can't use COM Interop, then you can't programmtically create an Excel workbook/worksheet in code.

You could however create a DTS package that could create the Excel file you need, but would not allow you to perform merge operations or formatting of the data.

You could have a pre-formatted sheet that is then populated each time though.

Answer 3

Ok if you can't have Excel installed on the server and use COM Interop. Take a look at Aspose Cell

They have a solution specifically to get around this problem

Answer 4

you can use ExmWriter dll provided here .Its handy but with limited features. saves ur excel files as xml sheet 2003 format.