<?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 Unable to import xls/xlsx files!! in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-import-xls-xlsx-files/m-p/2369187#M132357</link>
    <description>Hi all, 
&lt;BR /&gt;I'm using TOS DI 6.2.1 (x64) on Windows Server 2012 R2 and jdk 1.8.0_101&amp;nbsp; 
&lt;BR /&gt;I'm trying to create metadata for a 
&lt;B&gt;very very simple&lt;/B&gt; excel file with an only character in A1 cell but the following error occurs: 
&lt;BR /&gt; 
&lt;PRE&gt;Failed to generate code.&lt;BR /&gt;Preview error. Some settings must be changed.&lt;BR /&gt;Note: Preview errors are generally due to a wrong encoding setting.&lt;BR /&gt;org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)&lt;BR /&gt;org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)&lt;BR /&gt;org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)&lt;BR /&gt;org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)&lt;/PRE&gt; 
&lt;BR /&gt;I tried some different encoding types and both xls and xlsx format but without success. 
&lt;BR /&gt;Can anybody help me to understand this strange behavior? 
&lt;BR /&gt;I attached a sample zip file containing two files (xls and xlsx) I'm using to understand the issue. 
&lt;BR /&gt;Please, help me&amp;nbsp; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MADq.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/146464i525272F95B61C2BD/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MADq.png" alt="0683p000009MADq.png" /&gt;&lt;/span&gt; 
&lt;BR /&gt;Many thanks in advance 
&lt;BR /&gt; 
&lt;A href="https://community.talend.com/legacyfs/online/membersTempo/57175/sample_files.zip.zip" target="_blank"&gt;sample_files.zip.zip&lt;/A&gt;</description>
    <pubDate>Tue, 09 Aug 2016 16:29:30 GMT</pubDate>
    <dc:creator>Rosanero4Ever</dc:creator>
    <dc:date>2016-08-09T16:29:30Z</dc:date>
    <item>
      <title>Unable to import xls/xlsx files!!</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-import-xls-xlsx-files/m-p/2369187#M132357</link>
      <description>Hi all, 
&lt;BR /&gt;I'm using TOS DI 6.2.1 (x64) on Windows Server 2012 R2 and jdk 1.8.0_101&amp;nbsp; 
&lt;BR /&gt;I'm trying to create metadata for a 
&lt;B&gt;very very simple&lt;/B&gt; excel file with an only character in A1 cell but the following error occurs: 
&lt;BR /&gt; 
&lt;PRE&gt;Failed to generate code.&lt;BR /&gt;Preview error. Some settings must be changed.&lt;BR /&gt;Note: Preview errors are generally due to a wrong encoding setting.&lt;BR /&gt;org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)&lt;BR /&gt;org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)&lt;BR /&gt;org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:1042)&lt;BR /&gt;org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)&lt;/PRE&gt; 
&lt;BR /&gt;I tried some different encoding types and both xls and xlsx format but without success. 
&lt;BR /&gt;Can anybody help me to understand this strange behavior? 
&lt;BR /&gt;I attached a sample zip file containing two files (xls and xlsx) I'm using to understand the issue. 
&lt;BR /&gt;Please, help me&amp;nbsp; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MADq.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/146464i525272F95B61C2BD/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MADq.png" alt="0683p000009MADq.png" /&gt;&lt;/span&gt; 
&lt;BR /&gt;Many thanks in advance 
&lt;BR /&gt; 
&lt;A href="https://community.talend.com/legacyfs/online/membersTempo/57175/sample_files.zip.zip" target="_blank"&gt;sample_files.zip.zip&lt;/A&gt;</description>
      <pubDate>Tue, 09 Aug 2016 16:29:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unable-to-import-xls-xlsx-files/m-p/2369187#M132357</guid>
      <dc:creator>Rosanero4Ever</dc:creator>
      <dc:date>2016-08-09T16:29:30Z</dc:date>
    </item>
    <item>
      <title>Re: Unable to import xls/xlsx files!!</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-import-xls-xlsx-files/m-p/2369188#M132358</link>
      <description>The issue isn't due to excel files but rather to code generation. Executing TOS DI with administrator privileges all works well.&lt;BR /&gt;I'm a TOS DI user from 5.0 version (about 4 years) and this is the first time I need to execute the application as administrator.&lt;BR /&gt;I'll ask to my admins team&lt;BR /&gt;Thanks the same for your help</description>
      <pubDate>Tue, 09 Aug 2016 16:57:09 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unable-to-import-xls-xlsx-files/m-p/2369188#M132358</guid>
      <dc:creator>Rosanero4Ever</dc:creator>
      <dc:date>2016-08-09T16:57:09Z</dc:date>
    </item>
  </channel>
</rss>

