Microsoft Excel Worksheet

  • 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
headerRowsToIgnore="1"
footerRowsToIgnore="1"
sheetName="Sheet1"
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>