Files tab

Use the Files tab to enter the following options to define the location of the Microsoft Excel source files:

Option	Description
Spread sheet type (engine)	Select the spreadsheet type. The following types are supported: Excel 97-2003 XLS: This is the default engine and the backwardly compatible type for Excel files, which is provided by the JXL software backend. Excel 2007 XLSX (Apache POI): Allows you to read all known Excel file types. Functions are provided by the Apache POI project. Note: If using password protected worksheets, you must set the Spread sheet type (engine) to Excel 2007 XLSX (Apache POI). Excel 2007 XLSX (Apache POI Streaming): Allows you to read large Excel files. Open Office ODS: Allows you to read OpenOffice spreadsheets using the ODFDOM engine.
File or directory	Specify the source location if the source is not defined in a field. Click Browse to navigate to your source file or directory. Click Add to include the source in the Selected Files table.
Regular expression	Specify a regular expression to match file names within a specified directory.
Exclude regular expression	Specify a regular expression to exclude file names within a specified directory.
Password	Specify the password to open the Excel file when password protection is set for Excel 2007 XLSX (Apache POI).
Accept filenames from previous steps	Select the previous step that contains file names and the input field for reading in your data.