# Append Range

> `UiPath.Excel.Activities.Business.AppendRangeX`

`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](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) 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](https://docs.uipath.com/studiox/docs/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** - Select 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** - Select 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.