Dataset to Cells Action

Declaration

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

See Also

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

Description

Sets the text of a selected cell range in an established Excel session with the values contained in a dataset.

Practical Usage

To set the contents of cells in a Microsoft Excel document that was previously created or opened using AutoMate's Excel actions to the contents of an AutoMate dataset. This action is only useful in conjunction with the other Excel actions found in AutoMate.

IMPORTANT: The Excel actions in AutoMate 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.

Parameters

General Tab

Session Name

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

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 it's default value.

Dataset

Variable, Required
MARKUP: DATASET="mydatasetname"

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

Row

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

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

Column

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

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

Cell Reference

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

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.

Worksheet Name

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

Specifies the name of the new worksheet that the text will be set to. If left blank or omitted, the current active worksheet will be used.

Include Column Names

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

Outputs the dataset column names as the first row.  The dataset values are then output in subsequent rows.

Notes

Custom Description

This action includes the Description tab for entering a custom step description.

More on setting custom step description

Standard Error Handling Options

This action also includes the standard Error Causes and On Error failure handling options/tabs.

More on Error Handling Options

Variables and Expressions

All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, %Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.

More on variables
More on expressions

More on the expression builder

Example

NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.

<AMEXCELOPENWORKBOOK WORKBOOK="c:\excellfile.xls">

     <AMEXCELDATASETTOCELLS DATASET="mydataset" CELLREF="A1" WORKSHEET="Sheet1">

<AMEXCELCLOSEWORKBOOK>

.