Exporting to multiple excel worksheets from asp.net?

[=?Utf-8?B?RGF2ZQ==?=]

Hi,

I'm using ASP.NET 1.1 and trying export a dataset with multiple datatables
(each to it's own Excel worksheet.)

I've successful bound a DataTable a DataGrid using the code below but I
don't know how to create multiple worksheets tabs to correspond to each
datatable.

Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Charse t = "";
this.EnableView State = false;
StringWriter sw = new StringWriter();
HtmlTextWriter ht = new HtmlTextWriter( sw);
DataGrid1.Rende rControl(ht);
Response.Write( sw.ToString());
Response.End();

[Mark Rae]

"Dave" <Da**@discussio ns.microsoft.co mwrote in message
news:80******** *************** ***********@mic rosoft.com...

I'm using ASP.NET 1.1 and trying export a dataset with multiple datatables
(each to its own Excel worksheet.)

No problem.

I've successfully bound a DataTable a DataGrid using the code below but I
don't know how to create multiple worksheets tabs to correspond to each
datatable.

Ah, well for that you have two choices:

1) Use the Excel XML schema file format:
http://www.microsoft.com/downloads/d...displaylang=en

2) Use a 3rd-party product like this:
http://www.aspose.com/Products/Aspos...s/Default.aspx

Don't consider trying to use Office automation, though... it's not designed
for this kind of scneraio, and Microsoft strongly advise against it to the
extent that they will not support any application which uses it:
http://support.microsoft.com/default...US;q257757#kb2