Description

Opens an existing Microsoft Excel document and creates an associated session for manipulating it. This action is only useful in conjunction with the other Excel actions found in Automated Workflow.

IMPORTANT: The Excel actions in Automated Workflow use the Microsoft Excel automation engine to perform their work, because of this Microsoft Excel must be licensed and installed on the system to use the Excel Actions.

Declaration

<AMEXCELOPENWORKBOOK WORKBOOK="text" SESSIONNAME="text" VISIBLE="yes/no">

Example

<AMEXCELOPENWORKBOOK WORKBOOK="c:\book.xls"><AMEXCELSETCELL NEWVALUE="Set this data here" CELLROW="1" CELLCOLUMN="1"><AMEXCELSETCELL NEWVALUE="and this here" CELLROW="2" CELLCOLUMN="1"><AMEXCELCLOSEWORKBOOK>

General Tab Parameters

Workbook: Specifies the name of the Excel file that should be opened.

Text, Required
MARKUP: WORKBOOK="c:\file.xls"

Session name: Specifies the session name to identify this document in subsequent Excel steps. This allows several Excel files to be open simultaneously. If only working with one document at a time, this value should not be changed from its default.

Text, Optional - Default "Default"
MARKUP: SESSION="YES"

Workbook is invisible: When enabled (selected), specifies that when working with the workbook the Microsoft Excel Window will not be displayed (processing will occur in the background). Usually this option should be left unchecked when building/debugging, but enabled for production.

Yes/No, Optional - Default NO
MARKUP:
a) VISIBLE="no"

See Also

Create Workbook,  Close Workbook, Add Worksheet, Activate Worksheet, Get Cell, Set Cell, Cells to Dataset, Dataset to Cells