UiPath Activities

The UiPath Activities Guide

Read Column

UiPath.Excel.Activities.ReadColumn

Reads the values from a column beginning from the cell specified in the StartingCell field, and stores them in an IEnumerable <object>variable.

Properties

Input

  • StartingCell - The cell from which to start extracting the column data. Only string variables and strings are supported.

Note:

Strings must be placed between quotation marks.

  • WorkbookPath - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used. Only String variables and strings are supported.
  • SheetName - The name of the sheet in which the column that you want to read is. By default, this is filled in with "Sheet1." Only String variables and strings are supported.

Output

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

Options

  • Password - The password of the Excel workbook, if necessary. Only String variables and strings are supported.
  • PreserveFormat - Selecting this check box keeps the formatting of the cell that you want to read. By default, the check box is cleared.

Common

  • DisplayName - The display name of the activity.

Misc

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

Updated 2 months ago


Read Column


Suggested Edits are limited on API Reference Pages

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