Sheet panel

This panel includes fields for setting security for the spreadsheet in the MS Excel output file.

Field	Description
Sheet name (max. 31 characters)	Specify the worksheet's name in the MS Excel file to write the incoming rows from PDI. Variables or parameters can be used in this field.
Make this the active sheet	Specify whether the MS Excel file opens by default on the Excel sheet, above. Select this option to make the specified sheet the default when the file opens in Excel. Clear this option if you do not want to set a default sheet.
If sheet exists in output file	Specify whether to replace an existing Excel sheet in the output file with the new sheet or to keep the original. For example, you may be using a template sheet or writing to existing files, and therefore may choose to overwrite or replace the sheet. Select Write to existing sheet to keep the existing sheet and write the new data to it. Select Replace with new sheet to overwrite the existing sheet with the new sheet in the output file.
Protect sheet? (XLS format only)	Specify whether to password protect the Excel sheet from changes. Select to protect the sheet from editing with a specified user and password. Clear to leave the sheet unprotected. Any user can make changes to it.
Protected by user	Specify the name of the user you want shown in MS Excel as password-protecting this sheet. Variables or parameters can be used in this field.
Password	Specify the password for unlocking the editing features for this sheet in MS Excel. Variables or parameters can be used in this field.