Unable to Read Excel File: No such entry:"EncryptionInfo"...

[mmngeoh]

Hi,

I am unable to read excel as I face the error message as below:

I checked my file and discovered that this is encrypted file but I have full access and control

Please help to troubleshoot the problem

[kevin_sturm]

Hello @mmngeoh,

Thank you for sharing your issue with us. Reading an encrypted Excel file actually might cause issues, indeed. Maybe this thread from the past helps you to overcome the problem?

Best regards,
Kevin

[mmngeoh]

hi @kevin_sturm,

I could not access to this link

[mlauber71]

@mmngeoh maybe you could check out this example:

How to enter the file's password using flow variable in Excel Reader?

@liuwenwen welcome to the KNIME forum. It seems you have to use credentials in order to handle passwords with Flow Variables: [image]

[kevin_sturm]

Thank you @mlauber71 for sharing your resource.
Trying to repost the thread from above, which worked on my end:

Access Password Protected Excel Files

Yes, you can access and upload data from encrypted excel file to nodes like Excel reader or CSV reader. But for doing this firstly you have to unlock password protected Excel file. If you don’t have any idea how to unlock encrypted Excel workbook then I can help you out. Well there are various ways to unlock Excel file password, here are the options: Using the Excel’s unprotect sheet feature modifying the File Extension Using online Excel password remover tool To get detailed information on…