returning Excel sheet with ASP
 

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

returning Excel sheet with ASP
 

check out http://www.greggriffiths.org/webdev/both/excel/ which covers
this.

Holli wrote:

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