Microsoft Excel Spreadsheet File Format .XLS Export Automation Options

 

When the program is driven from an automation script, an options string can be specified in the script that acts as the export options dialogs do in the program. The string consists of comma-separated parameters, which specify the behavior of the various export options.

 

Parameter

Type

Description

FileFormat

BIFF8, BIFF5

Specifies the Excel format compatibility for the export file.

BIFF8 = Excel 97

BIFF5 = Excel 95

Filter

string

XLS

ModuleID

integer

Numeric ID of the module to be exported.

 

0=entire viewer window

2=default

 

Example

This example shows how to export an XLS file with the various options.

 

CommandApi.Construct("Export")

CommandApi.Option("GuiEnabled", "False")

CommandApi.Option("ClearOptions", "False")

CommandApi.Option("Filter", "xls")

CommandApi.Option("Options", "FileFormat=BIFF8")

CommandApi.Option("Path", "C:/Path/To/Export/file.xls")

CommandApi.Option("PersistOptions", "True")

CommandApi.Option("ModuleId", "2")

CommandApi.Do()

 

Used by: Export

 

 

See Also

Automation Model