UiPath Activities

The UiPath Activities Guide

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. 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 plus buttonplus button 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 plus buttonplus button 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

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Options

Updated 5 months ago


Append Range


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.