Content tab

Microsoft Excel Input step Content tab

Use Content tab to configure which data values to retrieve. The following options are available:

Option	Description
Header	Select if the sheets specified in the Sheets tab contain a header row to skip.
No empty rows	Select if you do not want empty rows to appear in the output of this step.
Stop on empty rows	Select to stop reading the current sheet of a file when an empty line is encountered.
Limit	Specify a limit on the number of records generated from this step. Results are not limited when set to zero.
Encoding	Specify which text file encoding to use. Leave this option blank to use the default system encoding. On first use, PDI searches your system for available encodings. To use Unicode, specify UTF-8 or UTF-16.