Read_Rows
When Read_Rows is selected in the General tab, the output for the activity is as follows.
| Output Item | Data Type | Mode | Description |
|---|---|---|---|
| FilePath | String | Basic and Advanced | The location of the Excel file that you want to read. |
| processedData | Binary | Basic and Advanced |
The binary data obtained on the Input tab. Available only when Use Process Data check box is selected on the General tab. |
| SheetName | String | Basic and Advanced | The name of the read sheet. |
| Value | String | Basic and Advanced | The value of the cell in the read row. |
| IsFormulaCell | Boolean | Basic and Advanced | A value of true indicates the cell contains Excel formula, whereas a value of false indicates the cell does not contain Excel formula. |
| CellComments | None | Advanced | The attributes for a cell comments. The following fields are displayed: Value and Author. |
| CellStyle | None | Advanced | The attributes for a cell style. The following fields are displayed: FontStyle, Alignment, BackgroundColor, FillPattern, and WrapText. |
| TotalCellsReadInRow | Positive integer | Advanced | The number of cells in the read row. |
| NextRowPointer | Positive integer | Advanced | The number of the row that is next to the last read row. |
| TotalRowsInSheet | Positive integer | Advanced | The number of rows in the read sheet. |
| NextSheetPointer | Positive integer | Advanced | The number of the sheet that is next to the read sheet. |
| TotalSheetsInFile | Positive integer | Advanced | The number of sheets in the Excel file. |
Copyright © TIBCO Software Inc. All rights reserved.