Activate Cell Action

Used to activate a cell or range of cells in the active worksheet of a Microsoft Excel document that was previously created using the Create Workbook action or opened using the Open Workbook action. Ideal for selecting a cell or cells in order to perform an action, such as formatting the cells or entering values in them. Be aware that this action works only on the active worksheet. To activate a specific worksheet, use the Activate Worksheet action.

Declaration

Example 1 - Activate a single cell by position.

Example 2 - Activate a range of cells by position.

Activates a cell or range of cells within the currently active worksheet in an established Excel session.

AWE's Excel actions use Microsoft's Excel automation engine to perform their work. Therefore, Microsoft Excel must be licensed and installed on the system in order for these actions to work. Excel objects run in the context of the user executing them. If EFT is running as a Local System, then the Excel object is executed using the Local System profile. Before using an Excel action in Event Rules, refer to Globalscape Knowledgebase article #11089 for important information.

This action is only useful in conjunction with other Excel actions. It is not possible to use AWE's Excel actions on a spreadsheet that was not opened by the Open Workbook action or created by the Create Workbook action.

General Tab

Property	Type	Required	Default	Markup	Description
Session Name	Text	Yes	ExcelSess1	SESSION="Session7"	Specifies the session name to identify which document should be acted on. Numerous sessions can exist within a single task allowing several spreadsheets to be open simultaneously. If working with only one document, this can remain at the default name, which is Excelsess1.
Activate	Text	Yes	Cell By Reference	ACTION= "rangebyposition"	Specifies the cell selection method. The available options are: Cell by reference (Default): Activates a single cell, selected by its cell reference such as A1 or B3. Cell by position: Activates a single cell, selected by its row and column position. Range by reference: 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. Range by position: 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.
Cell reference	Text	Yes if activate method is Cell by Reference	(Empty)	CELLREF="B3"	The reference of the cell to activate. Active only if Cell by reference is the selected Activate parameter.
Row	Number	Yes if activate method is Cell by position	1	CELLROW="3"	The row of the cell to activate. Active only if Cell by position is the selected Activate parameter.
Column	Number	Yes if activate method is Cell by position	1	CELLCOLUMN="2"	The row of the cell to activate. Active only if Cell by position is the selected Activate parameter.
Upper Left Cell	Text	Yes if activate method is Cell by reference	(Empty)	UPPERLEFTREF="A1"	The reference of the upper left cell in the range of cells to activate. Active only if Range by reference is the selected Activate parameter.
Lower Right Cell	Text	Yes if activate method is Cell by reference	(Empty)	LOWERRIGHTREF="C5"	Specifies the reference of the lower right cell in the range of cells to activate. Active only if Range of cells by reference is the selected Activate parameter.
Upper Left Cell Row	Number	Yes if activate method is Cell by position	(Empty)	UPPERLEFTROW="1"	Specifies the row of the upper left cell in the range of cells to activate. Active only if Range of cells by position is the selected Activate parameter.
Upper Left Cell Column	Number	Yes if activate method is Cell by position	(Empty)	UPPERLEFTCOLUMN="1"	Specifies the column of the upper left cell in the range of cells to activate. Active only if Range of cells by position is the selected Activate parameter.
Lower Right Cell Row	Number	Yes if activate method is Cell by position	(Empty)	LOWERRIGHTROW="14"	The row of the lower right cell in the range of cells to activate. Active only if Range of cells by position is the selected Activate parameter.
Lower Right Cell Column	Number	Yes if activate method is Cell by position	(Empty)	LOWERRIGHTCOLUMN="3"	The column of the lower right cell in the range of cells to activate. Active only if Range of cells by position is the selected Activate parameter.