# Get Table Range

> `UiPath.Excel.Activities.ExcelGetTableRange`

`UiPath.Excel.Activities.ExcelGetTableRange`

Extracts the range of an Excel table from a specified spreadsheet. Can only be used in the Excel Application Scope or Use Excel File activities.

## Properties

:::note
Strings must be placed between quotation marks.
:::

#### Input

* **TableName** - The name of the table for which to get the range. Only String variables and strings are supported.
* **SheetName** - The name of the sheet from which to get the range. By default, this is filled in with "Sheet1." Only String variables are supported.

#### Options

* **IsPivot** - When selected, this option indicates that the specified table is a pivot one. By default, this check box is not selected.

#### Output

* **Range** - The range of the specified table. Only String variables and strings are supported.

#### Common

* **DisplayName** - The display name of the activity.

#### Misc

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

## Example of using the Get Table Range activity

You can see how the **Get Table Range** activity is used in an example that incorporates multiple activities.

To exemplify how to use this activity, we have built an automation project which also includes a **Get Table Range** activity.

You can check and download the example from [here](https://docs.uipath.com/activities/other/latest/productivity/table-functions)