Read Row

Read row values from excel sheet.

Reads the values from a row beginning with the cell specified in the row index property field, and store it in a variable.

This activity can only be used after the Open Excel File activity.

Input

  • Input : ExcelHandle Variable A variable name that references the opened excel file handle.

  • Sheet Name : String Argument The name of the sheet in which the row of data is to be read.

  • Row Index : Integer Argument The row index to be read.

  • Preserve Format :

    • True - keeps the formatting of the excel row that you want to read.

    • False - Read the row without formatting. Default

Output

  • Row Data: IEnumerable Variable Stores the specified row of data based on the row index in an IEnumerable variable.

Last updated