activities
latest
false
Productivity Activities
Last updated Oct 3, 2024

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

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.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.