ExcelReaderWorker
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.