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 name of the worksheet within the MS Excel file in which to write the incoming rows from PDI. Variables or parameters can be used in this field. |
| Make this the active sheet (check box) |
If checked, the MS Excel file will open by default on the above sheet when the file is opened in Excel.
|
| If sheet exists in output file |
If the sheet already exists in the output file, decide if you want to replace it with the new sheet or keep the original sheet. For example, you may be using a template sheet or writing to existing files, and therefore may choose to overwrite or replace the sheet.
|
| Protect sheet? (XLS format only) (check box) |
The XLS file format allows to protect an entire sheet from changes. If
selected, you need to provide a password. MS Excel will indicate that the sheet was
protected by the user you specify here.
|
| 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. |