# Files tab

![Microsoft Excel Input step Files Tab](/files/GdmfiQ0oypkuNb0L84zb)

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)**           | <p>Select the spreadsheet type. The following types are supported:</p><ul><li><strong>Excel 97-2003 XLS</strong>: This is the default engine and the backwardly compatible type for Excel files, which is provided by the JXL software backend.</li><li><strong>Excel 2007 XLSX (Apache POI)</strong>: Allows you to read all known Excel file types. Functions are provided by the Apache POI project.</li></ul><p><strong>Note:</strong> If using password protected worksheets, you must set the <strong>Spread sheet type (engine)</strong> to Excel 2007 XLSX (Apache POI).</p><ul><li><strong>Excel 2007 XLSX (Apache POI Streaming)</strong>: Allows you to read large Excel files.</li><li><strong>Open Office ODS</strong>: Allows you to read OpenOffice spreadsheets using the ODFDOM engine.</li></ul> |
| **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.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pdia-data-integration/10.2-data-integration/pdi-transformation-steps-reference-overview/microsoft-excel-input/options-microsoft-excel-input/files-tab.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.