Activities
latest
false
Banner background image
Productivity Activities
Last updated Mar 27, 2024

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 docs image 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.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.