Append Range
AutomatR.Excel.Activities.AppendRange
The "Append Range" activity in AutomatR is part of the Excel activities package, designed to add information stored in a DataTable variable to the end of a specified Excel spreadsheet. This activity enhances automation capabilities in Excel by allowing the dynamic appending of data from DataTables.
NOTE: This activity can copy data in a table, range, or sheet and pastes it after existing data in another specified table, range, or sheet. This activity can only be used in Excel Root activity.
You can copy values, formulas, number and cell formats, and transpose (rotate) data. The data is copied to the destination as follows:
- If appending to a table, the existing table is expanded to include the copied data.
- If appending to a range, the existing range is expanded to include the copied data.
- If appending to a sheet, the copied rows are added starting with the first empty row below the rows with data in the sheet.
The following table lists supported copy-append combinations:
| Copy from | Append to |
|---|---|
| Sheet | Sheet |
| Range | Sheet |
| Range | Range |
| Range | Cell |
| Cell | Cell |
| Cell | Range |
Properties
| Name | Description |
|---|---|
| Input | |
| Data Table | Specifies the DataTable variable containing the information to be appended to the Excel spreadsheet. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Append Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to use:
- Drag and drop the "Append Range" activity onto the workflow.
- Configure the properties by specifying the DataTable variable containing the information to be appended.
- Optionally, configure the delay.
- Execute the workflow to append the specified data to the Excel spreadsheet.
Example: Consider an example where the "Append Range" activity is used to append data from a DataTable variable to an existing Excel spreadsheet:
Append Range:
Data Table: dataTableVariable
Delay: 2
In this example, the activity appends the information stored in the DataTable variable "dataTableVariable" to the end of the specified Excel spreadsheet. The optional delay is set to 2 seconds, providing time for any necessary synchronization.