# Get Table Range

> Get Table Range activity that extracts the range of an Excel table from a specified spreadsheet.

`UiPath.Excel.Activities.ExcelGetTableRange`

## Description

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.

## Project compatibility

Windows - Legacy | Windows

## 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)