"Rahul" <ra*******@hotmail.comwrote in message
news:Ou**************@TK2MSFTNGP04.phx.gbl...
>I want to create an excel file for report in asp.net 2.0 ...
No problem.
without having office installed on the server.
Hurrah! Glad to hear it!
Basically, you have three choices:
1) HTML
Create an HTML document and save it with a .xls extension - Excel will open
it and treat it like a native Excel file. This method is very simple and, of
course, free - however, it won't allow you to have more than one worksheet
in the Excel workbook...
2) Use the (relatively) new XML file format
http://www.microsoft.com/downloads/d...displaylang=en http://www.microsoft.com/downloads/d...displaylang=en
This is also free, and incredibly powerful, but not for the faint-hearted...
3) Use Aspose
http://www.aspose.com/Products/Aspos...s/Default.aspx
This is not free, but is extremely simple to use.