H
Holli
Hi,
I am creating an Excel sheet in a ASP using VBScript:
Set objXL = CreateObject("Excel.Application")
Set objWB = objXL.Workbooks.Open(filename)
The Excel file (filename) that I am opening serves as a template and
has some pivot tables in it. Then I am inserting som data into that
Excel sheet and at the end I would like to return the Excel sheet to
the user. I know I can do that by saving the file and then redirecting
the response to the saved file. However, that means I would have to
create a new file name each time the page is called and then I have to
do some clean-up later (which I am also not sure how to efficiently).
Can I somehow stream the Excel.Application object to the browser and
avoid having to save a temporary file to disk?
Any help is very much appreciated,
Holli
I am creating an Excel sheet in a ASP using VBScript:
Set objXL = CreateObject("Excel.Application")
Set objWB = objXL.Workbooks.Open(filename)
The Excel file (filename) that I am opening serves as a template and
has some pivot tables in it. Then I am inserting som data into that
Excel sheet and at the end I would like to return the Excel sheet to
the user. I know I can do that by saving the file and then redirecting
the response to the saved file. However, that means I would have to
create a new file name each time the page is called and then I have to
do some clean-up later (which I am also not sure how to efficiently).
Can I somehow stream the Excel.Application object to the browser and
avoid having to save a temporary file to disk?
Any help is very much appreciated,
Holli