Access Password Protected Excel Files

[mlauber71]

@AllisonE, @amartin

I built a workflow with Python module msoffcrypto-tool that can open a password-protected Excel files and then read them into KNIME

Password protected excel spread sheets

@jinbaba I created an example the uses the Python library msoffcrypto-tool to decrypt an excel file. As I said I had trouble with the R libraries. Some packages would only offer you the setting and removal of change protection but not decryption like this one does [image]

use python library msoffcrypto to decrypt excel file and read it back into...