Dataset to Cells Action—Setting Properties

The Dataset to Cells action is used to populate cells in an Excel worksheet with the data from a dataset. The worksheet must be open in an existing Excel session that was created in an earlier step using an Open Workbook or Create Workbook action. Also the dataset must be created in an earlier step using an action such as SQL Query.

Note: You must have Microsoft Excel licensed and installed on your system to use any of the AutoMate Excel actions.

To set Dataset to Cells properties

  1. From the Task Builder Available Actions pane, open the Excel folder and double-click the Dataset to Cells action or drag it into the Steps pane.

  2. In the Session name box, enter the session name. If your task has only one Excel session and you did not change the default session name when you created it (recommended), you can use the default entry.

  3. In the Dataset box, select the dataset.

  4. To indicate the position in the worksheet where the data is to be placed, enter the row and column number for the upper left cell in the Row and Column boxes.

    or

    To select the position by Excel reference (such as A1 or B5), click Upper left cell by reference and enter the reference in the Cell reference box.

  5. To use a worksheet other than the currently active one, click Use specific worksheet and enter the worksheet name in the corresponding box.

  6. To include column names, click Include column names. If this is not selected, only the data rows will be copied.

  7. To set the Description tab properties, refer to Description Tab Options.

  8. To set the Error Causes and On Error tab properties, refer to Step Error Handling.

  9. When finished, click OK to save settings and close the properties dialog window.

See Also

About Actions

Adding Task Steps

Dataset to Cells Action