KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter (and hind and unhide your worksheet)

KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter (and hind and unhide your worksheet)

There are limited ways to protect an Excel file using the Python package [ openpyxl](https://openpyxl.readthedocs.io/en/stable/protection.html). But it would only offer protection from some changes (not from opening the file) and the password would be stored hashed - so no real hurdle there.

In general I think most password protections for Office files are more there to prevent accidental editing to keep a fixed structure - but they are insufficient for real protection

External resources

• original discussion
• protect with openpyxl
• How to Set Up Your Python Extensions
• HUB: KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter
• more OpenPyxl examples
• BLOG: How to Set Up Your Python Extensions
• forum: check if a worksheet is hidden