UiPath Activities

The UiPath Activities Guide

UiPath.Excel.Activities.ExcelReadRow

Reads the values from a row beginning with the cell specified in the StartingCell field, and stores it in an IEnumerable<object> variable. Can only be used in the Excel Application Scope activity.

Properties

Common

  • DisplayName - The display name of the activity.

Input

  • StartingCell - The cell from which to start extracting the row data. By default, this is filled in with "A1". Only string variables and strings are supported.
  • SheetName - The name of the sheet in which the row that you want to read is. By default, this is filled in with "Sheet1." Only String variables and strings are supported.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

  • PreserveFormat - Selecting this check box keeps the formatting of the row that you want to read. By default, the check box is cleared.

Output

  • Result - Stores the information from the specified spreadsheet row in an IEnumerable<object> variable. Only IEnumerable <object> variables are supported.

Example of how to use the Read Row activity

To exemplify how to use this activity, we have built an automation project which reads information from a row found in an Excel file. You can download the example from here.

Updated 10 months ago


Read Row


Suggested Edits are limited on API Reference Pages

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