Outputing to different Excel worksheet

hddavie · February 25th, 2010, 04:02 PM

I can successfully output my .asp table to an Excel spreadsheet, but what I need to do is to be able to output to a specfic worksheet in the spreadsheet.

The end user needs a one click answer to his problem.

I generate the raw data then two different summary pages, all need to be in the Excel spreadsheet.

End product would have the following tabs;
Summary 1,
Summary 2,
Raw Data

I'm outputing with the following code;

Code:

<%
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment;filename=whatEver.xls"

Thank you for your help

Old Pedant · February 25th, 2010, 05:22 PM

Nope, not when you create the Excel that way.

See, you aren't *really* creating Excel data when you use the ContentType stuff. You are really just telling the *browser* that you want it to *TREAT* your data as Excel data. And so then the browser invokes the Excel plugin (if it exists! what about people who don't have Excel on their computers?) and says "here's the data". And you really don't even have control over what worksheet the data goes into.

If you really need to create a ".xls" file with multiple sheets, you will have to do it all server-side, creating and writing to Excel directly from your ASP code. That's not as easy.