Parameters | Description |
---|---|
tabSheet | Excel sheet name. |
mainElementName | Business object name. |
columns | Columns to process separated by ;. |
rowHeader | Row that contains the header. - Default value: ‘1’ |
rowStartData | Row number from where the data starts. |
numberOfRows | Number of rows to process. Default value: process all the rows available in the excel sheet. |
columnForStopDef | Column name to stop reading of rows. If this column is empty the reader will stop reading. Default value: ‘A’ |
nrOfEmptyRowsToStop | Number of empty rows to stop reading of rows. Default value: ‘5’ |
unitOfMeasurement | M/F(Meters/Feet) Default value: 'M' |
referenceDateCell | Cell reference containing the reference date. Default value: System date. When a reference date is filled in the document, this reference date will be used. |
referenceDate | Reference date Default value: System date. Example: 2015-01-31 |
referenceDateElementName | XML node name containing the reference date from the referenceDateCell. |