The Selected files table shows files or directories to use as source locations for input. This table is populated by specifying File or directory, then by clicking Add. The Microsoft Excel Input step tries to connect to the specified file or directory when you click Add to include it into the table.
The table contains the following columns:
| Column | Description |
|---|---|
| File/Directory | The source location indicated by clicking Add |
| Wildcard (RegExp) | Wildcards as specified in Regular expression |
| Exclude wildcard | Excluded wildcards as specified in Exclude regular expression |
| Required | Required source location for input |
| Include subfolders | Whether subfolders are included within the source location |
Click Delete to remove a source from the table. Click Edit to remove a source from the table and return it back to the File or directory option.
Use Show filename(s) to display the file names of the sources successfully connected to the Microsoft Excel Input step.