UiPath.Excel.Activities.Business.AppendRangeX

📘

Note:

This activity was first introduced in the UiPath.Excel.Activities v2.8.0-preview activities package.

Copies the data in a table, range, or sheet and pastes it after existing data in another specified table, range, or sheet. 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:

To learn how to use this activity, see Tutorial: Extracting Table Data from a Web Page and Editing It in Excel.

In the Body of the Activity

• Append after range - Click 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 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).

Properties

Common

• Display Name - 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.