Read_Rows

When Read_Rows is selected in the General tab, the input for the activity is as follows.

Input Item Data Type Mode Description
FilePath String Basic and Advanced Enter the absolute path for the Excel file with double quotation marks, where the cell values in specified rows are read.
Note: The FilePath is not displayed when Use Process Data check box is selected on the General tab.
processData Binary Basic and Advanced Get binary data on the Input tab when Use Process Data check box is selected on the General tab.

Available only when Use Process Data check box is selected on General tab.

SheetName|SheetPointer None Basic and Advanced Select SheetName or SheetPointer to read the cell values in specified rows in the Excel file.
Note: Before selecting SheetName or SheetPointer, complete the following steps:
  1. Drag SheetName|SheetPointer under the Sheet node in the XPath Expression view to the Data Source view. The Drop window opens.
  2. In the Drop window, select SheetName or SheetPointer from the list. Click Finish.
SheetName String Basic and Advanced Enter the name of the sheet with double quotation marks, where the rows are read.
Note: If the maximum length of the sheet name is more than 31 characters, the process can run successfully and only the first 31 characters of the sheet name are used.
SheetPointer Positive integer Basic and Advanced Enter the index number of the sheet, where the rows are read.
StartingRowPointer Positive integer Advanced Specify the starting row pointer, where the rows start to be read.
RowChunkSizeToRead Positive integer Advanced Specify the amount of rows to be read.