Excel Spreadsheet .XLSX Import Automation Options

 

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

 

Parameter

Type

Description

Filter

string

XLSX

Sheet

integer

Set to the integer representing a specific sheet you would like to import.

 

Example

This example shows how to import an Excel XLSX file with the various options.

 

CommandApi.Construct("Import")

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

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

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

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

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

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

  CommandApi.Option("Options", "Sheet=4")

  CommandApi.Option("Path", "C:/Path/To/Import/file.xlsx")

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

CommandApi.Do()

 

Used by: Import

 

 

See Also

Automation Model