The Microsoft Excel Output step has the following tabs and options:
| Option | Description |
|---|---|
| Step name | Specify the unique name of the Microsoft Excel Output step on the canvas. You can customize the name or leave it as the default. |
| Filename | Specify the filename of the spreadsheet for this step to read. |
| Create parent folder | Select to create a parent folder. |
| Do not create file at start | Select to create the output file after completion of this step. This avoids the creation of empty files when no rows are in the data stream. |
| Extension | Specify a three-letter file extension to append to the created file name. |
| Include stepnr in filename | Select to add a copy number in the output file names before the extension. For example: nnnn_0.ext |
| Include date in file name | Select to include the system date in the filename. For example: _20101231 |
| Include time in file name | Select to include the system time in the filename. For example: _235959 |
| Specify Date time format |
Select to create a filename which includes a date and time stamp that follows the selection you choose from the enabled down-down list. Selecting this option disables the Include date in filename option and the Include time in file name option. |
| Date time format | Specify the chosen date and time format for the filename. This option requires Specify Date time format (above) to also be selected. |
| Show file name(s) (button) | Click to display a simulated list of the files this step will generate. The simulation depends on the number of rows that will go into each file. |
| Add filenames to result | Select to add the filenames to the internal filename result set. This internal result set can be later used to process all the created files. |