Append Range

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. If the sheet does not exist, a new one is created with the name indicated in the SheetName field. 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

• Excel range to append - Click the plus sign, then select a named range, table, or sheet you want to copy. You can also select Indicate in Excel to open the file, and select a range directly from the file. Another method is to select Custom Input to enter the range manually, or Open in Advanced Editor and enter a VB expression.
• Append after range - Click the plus sign, then, select a named range, table, or sheet after which you want to paste the copied data. You can also select Indicate in Excel to open the file, and select a range directly from the file. Another method is to select Custom Input to enter the range manually, or Open in Advanced Editor to 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.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• See the options in the body of the activity.
• Starting in column - Append the data starting with the first empty cell in the specified column.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

• Has headers - See Has headers in the body of the activity.