Append Range
Appends range to sheet after existing range.
Input
- Excel Range To Append: If empty, the entire used range will be appended. (e.g. A1:C3)
- Type:
System.String - Required
- Type:
- Append After Range: Target range after which to append the new range.
- Type:
System.String - Required
- Type:
Options
- What To Copy: The value formatting for the new range.
- Type:
System.Int32 - Required
- Dropdown Options:
- All
- Values
- Formulas
- Formats
- Type:
- Exclude Headers: First row from the selected range will not be written to the destination.
- Type:
System.Boolean - Required
- Type:
- Has Headers: If true, the first row of the destination range contains column names and will be used to indentify the Starting column.
- Type:
System.Boolean - Required
- Type:
- Transpose: Insert columns as rows and rows as columns.
- Type:
System.Boolean - Required
- Type:
Details
- This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.