Content tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
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.