Excel and ASP - One file but 2 spreadsheets

[SonJ]

Hi there,

This problem has been bugging me for a while.

Just so you know, I am working with ASP, SQL Server 2000 and Microsoft Excel.

This is what I need to do: I have two sets of information, one for EventA and one for EventB. Both sets of information are held in a table in the database. I need to download all of this information into an Excel file (EVENTS.xls). The hitch is that they need to be downloaded into 2 separate spreadsheets within the same file ie one labelled EventA and the other labelled EventB .

Does anyone know if this is possible to do from an asp page?

My code to create the Excel file is as follows:

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

I just don't know how to create the separate worksheets!

Any help/ references/ tips would be much appreciated.

Thanks in advance.

 

[japes89]

I have used the following to manage Excel data, adding additional worksheets etc....

Set xlApp = CreateObject("Excel.Application&quot
set xlWb = xlApp.Workbooks.Open("Path\toxlsfile&quot
Set xlWs = xlWb.Worksheets("Sheet1&quot
xlWs.Range("A1&quot.Value = "somedata"
xlWb.Save
xlWb.Close
xlApp.Quit
set xlApp=nothing
set xlWb=nothing
set xlWs=nothing

Hope that helps

JP

_______________________________________________
OutsideIntranets.com
Stop wasting time, get to work

http://www.outsideintranets.com