Description

Activates a cell in a Microsoft Excel document that was previously created or opened using one of Automated Workflow's Excel actions. This action is only useful in conjunction with 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

<AMEXCELACTIVATECELL SESSION="Text" ACTION="Text [option]" CELLREF="Text" CELLROW="Text" CELLCOLUMN="Text" UPPERLEFTREF="Text" LOWERRIGHTREF="Text" UPPERLEFTROW="Text" UPPERLEFTCOLUMN="Text" LOWERRIGHTROW="Text" LOWERRIGHTCOLUMN="Text" />

Example

<AMEXCELACTIVATECELL SESSION="ExcelSess1" ACTION="rangebyposition" UPPERLEFTROW="1" UPPERLEFTCOLUMN="1" LOWERRIGHTROW="12" LOWERRIGHTCOLUMN="3" />

General Tab Parameters

Session name: Specifies the session name to identify which document should be acted on. This allows several Excel files to be open simultaneously. If working with only one document, this value should not be changed from its default value.

Text, Optional - Default "ExcelSess1"
MARKUP: SESSION="ExcelSess2"

Activate: Specifies the cell selection method. Options are:

• (Default) Cell by reference. Activates a single cell, selected by its cell reference such as A1 or B3.

• cellbyposition: Cell by position. Activates a single cell, selected by its row and column position.

• rangebyreference: Range of cells by reference. Activates a range of cells, selected by the cell reference for the upper left and lower right cells in the range.

• rangebyposition: Range of cells by position. Activates a range of cells selected by the row and column positions of the upper left and lower right cells in the range.

Text [options], Optional - default "cell by reference"
MARKUP: ACTION="rangebyposition"

Cell reference: Specifies the reference of the cell to activate. Active only if Cell by reference [Default] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: CELLREF="B3"

Cell by position:

Row: Specifies the row of the cell to activate. Active only if Cell by position [CELLBYPOSITION] is the selected Activate [ACTION] parameter.  

Text, Optional - Default "1"
MARKUP: CELLROW="3"

Column: Specifies the column of the cell to activate. Active only if Cell by position [CELLBYPOSITION] is the selected Activate [ACTION] parameter.   

Text, Optional - Default "1"
MARKUP: CELLCOLUMN="2"

Range of cells by reference:

Upper Left Cell: Specifies the reference of the upper left cell in the range of cells to activate. Active only if Range of cells by reference [rangebyreference] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: UPPERLEFTREF="A1"

Lower Right Cell: Specifies the reference of the lower right cell in the range of cells to activate. Active only if Range of cells by reference [rangebyreference] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: LOWERRIGHTREF="C5"

Range of cells by position:

Upper Left Cell Row: Specifies the row of the upper left cell in the range of cells to activate. Active only if Range of cells by position [rangebyPOSITION] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: UPPERLEFTROW="1"

Upper Left Cell Column: Specifies the column of the upper left cell in the range of cells to activate. Active only if Range of cells by position [rangebyPOSITION] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: UPPERLEFTCOLUMN="1"

Lower Right Cell Row: Specifies the row of the lower right cell in the range of cells to activate. Active only if Range of cells by position [rangebyPOSITION] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: LOWERRIGHTROW="14"

Lower Right Cell Column: Specifies the column of the lower right cell in the range of cells to activate. Active only if Range of cells by position [rangebyPOSITION] is the selected Activate [ACTION] parameter.

Text, Required if active
MARKUP: LOWERRIGHTCOLUMN="3"