Template panel

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

When you create new files or replace existing files, you may choose to create a copy of an existing template file instead. Please make sure that the template file is of the same type as the output file: both must be either .xls or .xlsx. This panel includes fields for using template files and sheets in your Excel output file.

Field Description
Use template when creating new files (check box)

Select this option if you want to use a specified MS Excel template to create the output file.

  • Select this option to specify an Excel template for use in creating the output file. If you select this option, you must also specify the template file name in the Template file field below.
  • Clear this option if you do not want to specify a template file.
Template file If you selected the Use template when creating new files check box above, then enter the template file name you want to use, or click the Browse button and navigate to it.
Use template when creating new sheets (check box)

Select this option if you want to use a specified template sheet to create the output sheet.

  • Select this option to specify a template sheet for use in creating the output sheet. If you select this option, you must also specify the name of the template sheet in the Template sheet field below.
  • Clear this option if you do not want to specify a template sheet.
Template sheet If you selected the Use template when creating new sheets check box above, then enter the template sheet name you want to use, or click the Browse button and navigate to it.
Hide Template sheet (check box)

Decide if you want the template sheet to be visible when the MS Excel output file is opened.

  • Select this option to hide the template sheet from users who open the output file.
  • Clear this option to show the template sheet to users who open the output file.