<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Open a file with protected view in Excel in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Open-a-file-with-protected-view-in-Excel/m-p/2345508#M113022</link>
    <description>&lt;P&gt;Could you try to use a different folder to store the file?&lt;/P&gt;&lt;P&gt;https://stackoverflow.com/questions/49377639/how-to-disable-protected-mode-for-excel-file-generated-using-apache-poi&lt;/P&gt;</description>
    <pubDate>Mon, 29 May 2023 12:37:32 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2023-05-29T12:37:32Z</dc:date>
    <item>
      <title>Open a file with protected view in Excel</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Open-a-file-with-protected-view-in-Excel/m-p/2345507#M113021</link>
      <description>&lt;P&gt;Hello everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have built a job that downloads an Excdel file from AWS S3, then reads it with the component tFileInputExcel.&lt;/P&gt;&lt;P&gt;Both in local and cloud I get the error tFileInputExcel_1 - java.lang.NullPointerException&lt;/P&gt;&lt;P&gt;When I open the downloaded Excel file (.xslx), I get the warning from Microsoft : the file is in Protected View.&lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;It seems to me that it is not possible to read an Excel file with the protected view enabled. &lt;/P&gt;&lt;P&gt;How can I read a file with the protected view enabled ? Can I click "enable editing" in Talend ?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;</description>
      <pubDate>Fri, 15 Nov 2024 21:46:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Open-a-file-with-protected-view-in-Excel/m-p/2345507#M113021</guid>
      <dc:creator>fabienb1</dc:creator>
      <dc:date>2024-11-15T21:46:52Z</dc:date>
    </item>
    <item>
      <title>Re: Open a file with protected view in Excel</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Open-a-file-with-protected-view-in-Excel/m-p/2345508#M113022</link>
      <description>&lt;P&gt;Could you try to use a different folder to store the file?&lt;/P&gt;&lt;P&gt;https://stackoverflow.com/questions/49377639/how-to-disable-protected-mode-for-excel-file-generated-using-apache-poi&lt;/P&gt;</description>
      <pubDate>Mon, 29 May 2023 12:37:32 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Open-a-file-with-protected-view-in-Excel/m-p/2345508#M113022</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2023-05-29T12:37:32Z</dc:date>
    </item>
  </channel>
</rss>

