Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
fabienb1
Contributor III
Contributor III
‎2023-05-23 05:27 AM

Open a file with protected view in Excel

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,

139 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2023-05-29 08:37 AM

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

139 Views
0 Likes