Package com.orchestranetworks.addon.dint.dataconnector.spec

Class ExcelSourceTableSpec.ExcelSourceTableSpecBuilder

java.lang.Object

com.orchestranetworks.addon.dint.dataconnector.spec.ExcelSourceTableSpec.ExcelSourceTableSpecBuilder

All Implemented Interfaces:

com.orchestranetworks.addon.dint.dataconnector.spec.InvalidDataExcelFileValidator

Enclosing class:

ExcelSourceTableSpec

public static final class ExcelSourceTableSpec.ExcelSourceTableSpecBuilder
extends java.lang.Object
implements com.orchestranetworks.addon.dint.dataconnector.spec.InvalidDataExcelFileValidator

Builder for creating an ExcelSourceTableSpec instance.

Method Summary

Modifier and Type	Method	Description
ExcelSourceTableSpec	build()	Builds the ExcelSourceTableSpec instance.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setColumnHeaderIncluded(boolean included)	Specifies if the first row is the header.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setInvalidDataFile(java.io.File file)	Sets the file where invalid records are written.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setListSeparator(char listSeparator)	Sets the list separator character.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setSheetName(java.lang.String sheetName)	Sets the sheet name.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setStartColumn(int startColumn)	Sets the start column.
ExcelSourceTableSpec.ExcelSourceTableSpecBuilder	setStartRow(int startRow)	Sets the start row.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.orchestranetworks.addon.dint.dataconnector.spec.InvalidDataExcelFileValidator

validate

Method Detail

build

public ExcelSourceTableSpec build()

Builds the ExcelSourceTableSpec instance.

setListSeparator

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setListSeparator(char listSeparator)

Sets the list separator character.

Parameters:

listSeparator - The list separator character.

Throws:

java.lang.IllegalArgumentException - If the list separator character is a backslash.

Since:

4.2.0

setSheetName

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setSheetName(java.lang.String sheetName)

Sets the sheet name.

Parameters:

sheetName - The sheet name. It can not be empty.

Throws:

java.lang.IllegalArgumentException - If the sheet name is empty

setStartRow

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setStartRow(int startRow)
                                                             throws DataIntegrationException

Sets the start row.

Parameters:

startRow - The start row of the data table.

Throws:

DataIntegrationException

setStartColumn

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setStartColumn(int startColumn)
                                                                throws DataIntegrationException

Sets the start column.

Parameters:

startColumn - The start column of the data table.

Throws:

DataIntegrationException

setColumnHeaderIncluded

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setColumnHeaderIncluded(boolean included)

Specifies if the first row is the header.

Parameters:

included - Sets true if the file contains header row.

setInvalidDataFile

public ExcelSourceTableSpec.ExcelSourceTableSpecBuilder setInvalidDataFile(java.io.File file)

Sets the file where invalid records are written.

Parameters:

file - The invalid data file.

Since:

4.5.0