export to Excel - multiple sheets & renaming sheets

11-12-03, 07:22 PM

Carl Corcoran

I'm developing a website for work that exports some reports to excel.
I am using the...

Response.AddHeader "Content-Disposition","attachment;filename=report.xls"
Response.ContentType = "application/vnd.ms-excel"

....strategy to do this. It works wonderfully except I cannot figure
out how to do two things:

1) specify a name for the worksheet that's exported (it names the
worksheet "blah.asp?q=123" when the user wants to see "Monthy Quotas"

2) generate multiple worksheets. The exported spreadsheet should have
about 6 tabs on the bottom that all contain different information in
the same report.

Please help!

11-12-03, 07:28 PM

Bob Barrows

Carl Corcoran wrote:
> I'm developing a website for work that exports some reports to excel.
> I am using the...
>
> Response.AddHeader
> "Content-Disposition","attachment;filename=report.xls"
> Response.ContentType = "application/vnd.ms-excel"
>
> ...strategy to do this. It works wonderfully except I cannot figure
> out how to do two things:
>
> 1) specify a name for the worksheet that's exported (it names the
> worksheet "blah.asp?q=123" when the user wants to see "Monthy Quotas"
>
> 2) generate multiple worksheets. The exported spreadsheet should have
> about 6 tabs on the bottom that all contain different information in
> the same report.
>
> Please help!

Create a spreadsheet in Excel that has the features you want, then save it
as html. Look at the source to see how the features are implemented.

HTH,
Bob Barrows

Similar Threads
Name multiple sheets in excel export? I have a report that when exported to Excel creates multiple sheets. Im doing this on purpose. I wanted know if anyone new a way to automatically name the Sheets in the Excel...
How to I export to multiple Excel Sheets in Access I posted a reply to an old question and am unsure if I should have just posted a new question so here it is: I would like to also export a databse to multiple worksheets in...
Export reports to excel with multiple sheets I have read a bunch of posts here and never really found an answer on how you export several reports to one excel spreadsheets with multiple worksheets. I am sure this is...
Export to multiple excel sheets Hi Everyone, I am trying to export a group of tables to an excel workbook and I would like to export table 1 to sheet 1, table 2 to sheet 2 etc. I am using...
Export data into multiple sheets in Excel Can anyone provide me with an example of exporting data from access into a single Excel file with multiple sheets? Access Help says that TransferText will do this, but...