Dataset to Cells Action

Description

Sets the text of a selected cell range in an established Excel session (a Microsoft Excel document that was previously created or opened using Automated Workflow's Excel actions) to the contents of an Automated Workflow dataset. 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

<AMEXCELDATASETTOCELLS SESSIONNAME="text" DATASET="text" CELLROW="text" CELLREF="text" CELLCOLUMN="text" CELLREF="text" WORKSHEET="text">

Example

<AMEXCELOPENWORKBOOK WORKBOOK="c:\excellfile.xls"><AMEXCELDATASETTOCELLS DATASET="mydataset" CELLREF="A1" WORKSHEET="Sheet1"><AMEXCELCLOSEWORKBOOK>

General Tab Parameters

Session name: Specifies the session name to identify which document should be changed from prior Excel steps. 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 "Default"
MARKUP: SESSION="YES"

Dataset: Specifies the dataset holding the data that should to set to the desired cells range at runtime.

Variable, Required
MARKUP: DATASET="mydatasetname"

Upper left cell by position:

Row: Specifies the row of the upper left cell where the data should be set. If specified, CELLCOLUMN must also be specified.

Text, Optional Default ""l
MARKUP: CELLROW="3"

Column: Specifies the column of the upper left cell where the data should be set. If specified, CELLROW must also be specified.

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

Upper left cell by reference: Specifies the reference of the upper left cell where the data should be set. This is an alternate method to specifying the row and column of the desired cell.  If specified, CELLROW and CELLCOLUMN are ignored.

Text, Optional Default ""
MARKUP: CELLREF="B3"

Use active worksheet or Use specific worksheet: Use the current active worksheet or specify the name of the new worksheet that the text will be set to.

Text, Optional Default ""
MARKUP: WORKSHEET="My Worksheet Name"

Include column names: When selected, outputs the dataset column names as the first row. The dataset values are then output in subsequent rows.

Yes/No, Optional - Default NO
MARKUP: INCLUDECOLUMNNAMES="YES"

See also

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