| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for keyword in sheet 1 and returning the whole row intosheet 2 | Excel Worksheet Functions | |||
| Matching and returning values to a master sheet in Excel 2007 | Excel Worksheet Functions | |||
| Max Value Across Worksheets Returning Sheet Name | Excel Discussion (Misc queries) | |||
| returning a sheet to blank orginal status? | Excel Discussion (Misc queries) | |||
| Returning data to Excel sheet from MS query | Excel Discussion (Misc queries) | |||
Hybrid Mode
