Open a file with protected view in Excel

[fabienb1]

Hello everyone,

I have built a job that downloads an Excdel file from AWS S3, then reads it with the component tFileInputExcel.

Both in local and cloud I get the error tFileInputExcel_1 - java.lang.NullPointerException

When I open the downloaded Excel file (.xslx), I get the warning from Microsoft : the file is in Protected View.

When I disable the Protected View (click on enable editing) and run the job again it works correctly and the component is able to read the file.

It seems to me that it is not possible to read an Excel file with the protected view enabled.

How can I read a file with the protected view enabled ? Can I click "enable editing" in Talend ?

Best Regards,

[Anonymous]

Could you try to use a different folder to store the file?

https://stackoverflow.com/questions/49377639/how-to-disable-protected-mode-for-excel-file-generated-using-apache-poi