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
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.2 Note: Not all extensions may be displayed.
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.