Content tab

Microsoft Excel Output Content tab

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: Specify UTF-8 or UTF-16 to use Unicode. Leave this option blank to use the default encoding on your system. 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.