Excel Tabs
 

Hi there,

I am developing an intranet querying system which
outputs data into excel sheets. using the
Response.ContentType = "application/vnd.ms-excel"
code, it is easy to produce simple excel sheet output
generated by a redirect from an aspx page. However, I want
my Excel workbooks to be a little more complex now.
Specifically, I want to subdivide my data table between
various named worksheets. Is there a way to create
multiple worksheets in an on-the-fly created workbook
created from an aspx page? Alternatively, I have written
many Macros in my time, and so is there a way to add some
code to the aboce content type line to create my excel
sheet from a specific template? I could simply add the
Macro to the template, and so either at workbook creation
time, or based on a ctrl + A (or something) command after
the workbook has been created, the macro would run and do
the sub division appropriately. I am almost certainly
going to be using this a lot in the coming months, and so
any guidance would be very much appreciated.

Thanks,

Paul.