The content tab has the following
options:
| Option | Description |
|---|---|
| Append | Select to append lines to the end of the specified file. If the file does not exist, a new one will be created. |
| Header | Select to display a header (defined in the Custom tab). The header will appear before the spreadsheet grid data. |
| Footer | Select to display a footer following the spreadsheet grid data. |
| Encoding |
Specify the text file encoding to use:
On first use, the PDI client searches your system for available encodings and populates this list accordingly. |
| Split every . . . rows | Specify a number of rows at which to split the file and start a new spreadsheet in which to continue data output. |
| Sheet name | Specify the name of the worksheet within the spreadsheet file. |
| Protect sheet? | Select to password protect the worksheet. You must also specify a password in the Password field. |
| Auto size columns | Select this option to automatically size the worksheet columns to the largest value. |
| Retain NULL values |
Select this option to preserve null values in the output. If this option is not selected, nulls are replaced with empty strings. |
| Use temporary file |
Select to create a temporary file that will be used during the generation of the workbook. If this option is not selected, the workbook is built entirely in memory. Setting this option involves an assessment of the trade-offs between memory usage and performance. |
| Temporary files directory | Specify a temporary files directory. |
| Use Template | Select to use a specified Excel template to create the output file. If you select this option, you must also specify the template filename in the Excel template field. |
| Excel Template | Specify the Excel template to be used. |
| Append to Excel Template | Select to append the output to the specified Excel template. |