UiPath Activities

Get Table Range

UiPath.Excel.Activities.GetTableRange

Extracts the range of an Excel table from a specified spreadsheet.

Properties

Input

  • TableName - The name of the table from which to get the range. Only String variables and strings are supported.

Note:

Strings must be placed between quotation marks.

  • WorkbookPath - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used. 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.
  • Password - The password of the Excel workbook, if necessary. Only String variables and strings are supported.

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.

Updated 2 years ago


Get Table Range


Suggested Edits are limited on API Reference Pages

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