Docs: SpeedGen ASP: SaveLocally Method

Method:

SaveLocally "aTemplateFile" "aOutputFile"

Purpose

Saves the file locally on the server

Parameters

aTemplateFile:

The Source Workbook (see notes about permissions)

aOutputFile:

The output (local) file. (see notes about permissions)

You must always specify the path either by using Server.MapPath() or explicitly eg. "d:\states.xls". DO NOT use "states.xls"

Returns

Nothing.

Example

myXLS_obj.SaveLocally "c:\states.xls", "d:\states.xls"

Description

Creates the Excel Workbook by processing the aTemplateFile and populating it with data.

If you are generating large files (more than 10,000 rows) or if you have a slow Server then you may want to use this method to generate a spreadsheet once in a while and place it somewhere where the client can download it, otherwise we recommend using Generate instead.

Notes

Read more about Streaming and Saving
You can use Response.Write in the script.
You can write Response Headers in the script.
You can use either Generate or SaveLocally in a script. You cannot use both!
Unlike the Generate Method, SaveLocally can be called multiple times in the Script.

Confused? Just ask us

Online Docs Table of Contents

KnowledgeBase

Microsoft® Excel is a Registered Trademark of Microsoft Corporation.