Excel Password Protection Attributes

The following Excel attributes and values are set by the ExcelAppenderUnit when the option Excel password for protection is used.

Attribute

Value

Select locked cells

true

Select unlocked cells

true

Format cells

true

Format rows

true

Insert columns

false

Insert rows

false

Insert hyperlinks

false

Delete columns

false

Delete rows

false

Sort

true

Use AutoFilter

true

Use PivotTable reports

true

Edit objects

false

Edit scenarios

false

Edit content

false