Excel

Microsoft Excel Worksheet
Parameter
Value
sheetName
The name of the sheet within the Excel file
headerRowsToIgnore
the number of records from the top of the file to ignore before the data starts (includes column header)
footerRowsToIgnore
the number of records from the bottom of the file to ignore
path
the path to the source file to load, this can reference an execution parameter
<ExcelDataSource
sheetName="Sheet1"
headerRowsToIgnore="1"
footerRowsToIgnore="1"
path="C:\Users\Cinchy\Sample.xlsx">
<Schema>
<Column name="Name" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true" />
<Column name="description" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true"
inputFormat="yyyy-mm-dd"/>
</Schema>
</ExcelDataSource>