UiPath.Excel.Activities.Business.AppendRangeX
Copies the data in a table, range, or sheet and pastes it after existing data in another specified table, range, or sheet. The activity can be used with Excel files selected for parent Use Excel File activities or with the Project Notebook.
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 |
To learn how to use this activity, see Tutorial: Extracting Table Data from a Web Page and Editing It in Excel.
Configuring the Activity
In the Body of the Activity
- Append after range - Click Plus
on the right side of the field and then, from the menu, select a named range, table, or sheet after which to paste the copied data, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor to enter a VB expression.
- What to append - Click Plus
on the right side of the field and then, from the menu, select a named range, table, or sheet to copy, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor and enter a VB expression.
- What to copy - Select how to copy the data. The following options are available: All (the default option), Values, Formulas, Formats.
- Transpose - If selected, the copied range is rotated (rows to columns and columns to rows). This option is not selected by default.
- Has headers - If selected, the first row in the copied range is considered a header row and is not copied. This option is not selected by default.
In the Properties Panel
Common
- DisplayName - The name displayed for the activity in the Designer panel.
Input
- See the options in the body of the activity.
Misc
- Private - If selected, the data used in the activity is not logged by StudioX.
Options
- Has headers - See Has headers in the body of the activity.
Updated 8 months ago