Read Range

UiPath.Excel.Activities.Business.ReadRangeX

Reads the value of an Excel range as a DataTable. The activity can be used with Excel files selected for parent Use Excel File activities or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

• Range - Click Plus on the right side of the field and then, from the menu, select a named range, table, or sheet to be read, or select Indicate in Excel to open the file and select a range directly from the file. Alternatively, you can select Custom Input to enter the range manually, or Open in Advanced Editor and enter a VB expression.
• Has headers - Select this option if the first row in the range is a header row.
• Visible rows only - Select this option to only read the visible rows. It ignores filtered and hidden values.

• Save to - The DataTable where to save the contents of the range. Click Plus on the right side of the field and then, from the menu, select one of the available options:

  • Data from the Project Notebook or a parent Excel file. For example, select an Excel file, and then select Indicate in Excel to indicate where to save the DataTable.
  • Copy to clipboard - Save the resulting DataTable to clipboard. To paste the data from the clipboard, use the Copy / Paste Range activity or other paste activities.
  • Save for Later Use - Prompts to provide a name to save the value for later use in the automation. The name can be changed afterwards.
  • Open in Advanced Editor - Enter a VB expression.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• Range - See Range in the body of the activity.

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.
• Read formatting - Select what formatting should be applied to the values. Null means that the formatting options are the same as for the parent card.
• Visible rows only - See Visible rows only in the body of the activity.

Note: For better performance, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option.

Output

• See the options in the body of the activity.