Hi,

I’m developing a asp.net application wherein I have a requirement to have a excel report download feature. The data from the database will be manipulated and filled in the excel file on click of a button at runtime and user should be able to download it.

Please let me know the best possible option to do it. I do not want to the COM interop.

Thanks in advance.

There is an example in this post here:

http://p2p.wrox.com/topic.asp?TOPIC_ID=65901

/- Sam Judson : Wrox Technical Editor -/

Thanks for the reply.

But the gridview object is rendered and used along with the datatable in the referred code.My excel file will contain multiple sheets and the no. of sheets are not fixed. At runtime I need to generate the excel file.

Regards,
K****ij

This really is the kind of this you should have checked google for first, as it is a very frequent request.

Top result for "multiple sheet excel spreadsheet asp.net" google search gives me this:

http://forums.asp.net/t/1207027.aspx

/- Sam Judson : Wrox Technical Editor -/