Write Range
AutomatR.Excel.Activities.WriteRange
The "Write Range" activity in AutomatR is part of the Excel activities package, facilitating the automation of writing data from a DataTable variable into a specified cell range within Microsoft Excel. This activity streamlines the process of populating Excel spreadsheets with data extracted from other inbound activities.
NOTE: This activity can only be used in Excel Root activity.
Properties
| Name | Description |
|---|---|
| Input | |
| Data Table | Enter the DataTable variable containing the data to be written into the Excel spreadsheet. DataTable variables storing extracted data from other activities. |
| Header | When enabled, considers column headers as the first row in the mentioned cell range. Boolean variables to enable or disable considering headers. |
| Starting Cell | Enter the cell value to start writing the data. String variables containing the cell value, e.g., "A1" or "B2". |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Write Range" activity onto the workflow.
- Configure the properties by specifying the DataTable variable, starting cell, and whether to include headers.
- Optionally, configure the delay.
- Execute the workflow to write the specified data from the DataTable into the designated cell range in Excel.
Important:
- Ensure that the Excel workbook is open and accessible.
- Provide a valid starting cell and DataTable variable containing the data to be written.
- Consider enabling the "Include Headers" option if the DataTable has column headers.