Docs: SpeedGen ASP: Generate Method

Method:

Generate "aTemplateFile" "aDownloadFile" aOpenInPlace

Purpose

Creates the Excel Workbook and streams it out to the Client.

Parameters

aTemplateFile:

The Source Workbook to populate.

aOutputFile:

The suggested name for the Excel Workbook. The user can override this when saving the file to disk, it is just a suggestion.

Important! If you specify a blank string then it will randomly create a file name. This is highly recommended. However, it will only work when aOpenInPlace is false. If aOpenInPlace is true then browser will use the name of the asp script as the filename. This is not the ideal solution but it is how asp + inline excel viewing works.

aOpenInPlace:

If True, opens the spreadsheet using in-place activation. This means that the browser will load the spreadsheet into the browser window and Excel's menu and toolbars will become available in the browser.

If False, the spreadsheet will be loaded into Excel. Warning! Internet Explorer 5.5 has a bug that causes the open dialog to open twice if aOpenInPlace is False. There is a fix for it, please see the Microsoft Knowledge Base Article

In either case, the user will first be prompted with an open dialog which will ask if the user would like to open the file or save it to disk. It is possible to suppress the showing of this dialog, instructions can be found here

Returns

Nothing.

Example

myXLS_obj.Generate "c:\states.xls", "states.xls", True

Description

Creates the Excel Workbook and streams it out to the Client. It can open the spreadsheet in place or launch Excel separately.

The Excel Workbook is created by processing the aTemplateFile and populating it with data.

There are absolutely no disk writes. Everything will be constructed in memory and streamed out to the client.

Notes

Read more about Streaming and Saving
You must not use Response.Write in the script!
You must not write any Response Headers unless you set the NoHeaders property to False.
The ASP Script must have read permission to access the file specified by aTemplateFile.
Only one call can be made to Generate per script.
You can use either Generate or SaveLocally in a script. You cannot use both!

Confused? Just ask us

Online Docs Table of Contents

KnowledgeBase

Microsoft® Excel is a Registered Trademark of Microsoft Corporation.