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.