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. To paste the data from the clipboard, use Copy/Paste Range or other dedicated pasting activities.

Note:

For details on how to use the options under the plus menu, check Designing automations in UiPath Studio.

Properties panel

Common

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

Input

• Range - Check 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 - Check Has headers in the body of the activity.
• Read formatting - The formatting that should be applied to the values. Select one of the following options:
  • (null) - The formatting options are the same as for the parent card.
  • Default - Applies the default formatting returned by Excel.
  • Raw Value - Retrieves the raw values from Excel and ignores all formatting.
  • Display Value - Retrieves the values as they are displayed in Excel.
• Visible rows only - Check 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

• Save to - The DataTable where to save the contents of the range. To paste the data from the clipboard, use Copy/Paste Range or other dedicated pasting activities. Select the plus icon and, from the dropdown menu, select one of the available options:

  • Use Variable - Use an existing variable to store the output.
  • Open in Expression Editor - Enter a VB expression.
  • Create Variable - Creates a new variable to store the output.