Exporting whole page content to Excel Sheet

[Althaf]

Hi all,
I'm trying to export all the contents of my page ( there are two Gridviews and two tables displaying in my page). How to export all this in a single Excel sheet?

Can anybody send me the coding(c#) for this problem.

Thanks in advance

Regards Althaf.

[Phil Weber]

Here's how to export a single DataGrid to Excel: http://support.microsoft.com/kb/317719 . To do this, I think you'll have to create another page that has all the data in a single grid.

The other option is to programatically generate an Excel file on the server. See if these help:

http://www.google.com/search?q=asp.net+automate+excel
http://www.google.com/search?q=asp.n...ate+excel+file