Can anyone tell me how to ? I can connect to unprotected excel files, but it says “directory not found” when trying to open password protected ones. I have tried to provide password in various property fileds as well as tried to change “authscheme” but no avail.
Kind regards
Hi
Unfortunately you will not be able to work with password-protected files as we do not support these with our products. The reason for this is because password-protected Excel sheets involve a different file structure that is proprietary to Microsoft, so it's not something we can possibly accommodate.
Let me know if there's anything else I can help with, I will be happy to do so!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers