Read Row

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 or Use Excel File activities.

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.