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.
- DisplayName - The display name of the activity.
- 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.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
- PreserveFormat - Selecting this check box keeps the formatting of the row that you want to read. By default, the check box is cleared.
- Result - Stores the information from the specified spreadsheet row in an
IEnumerable <object>variables are supported.
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 5 months ago