<?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: xlsx file: tFileInputExcel java.lang.RuntimeException: Not implemented in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/xlsx-file-tFileInputExcel-java-lang-RuntimeException-Not/m-p/2356232#M121806</link>
    <description>Hi
&lt;BR /&gt;I have reproduced this issue.
&lt;BR /&gt;You can report it on 
&lt;A href="http://jira.talendforge.org/secure/Dashboard.jspa" target="_blank" rel="nofollow noopener noreferrer"&gt;BugTracker&lt;/A&gt;.
&lt;BR /&gt;Regards,
&lt;BR /&gt;Pedro</description>
    <pubDate>Mon, 19 Mar 2012 03:31:18 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2012-03-19T03:31:18Z</dc:date>
    <item>
      <title>xlsx file: tFileInputExcel java.lang.RuntimeException: Not implemented</title>
      <link>https://community.qlik.com/t5/Talend-Studio/xlsx-file-tFileInputExcel-java-lang-RuntimeException-Not/m-p/2356231#M121805</link>
      <description>I'm trying to pull data from an Excel 2007 file that links to other excel files. In the Edit Excel File window when I try to preview the file I get the error below. If I try to run the job I get the same error. If I remove the links to other files I do not get this error and it works successfully. Is there any way to avoid this error without needing to change the Excel file? 
&lt;BR /&gt;Exception in component tFileInputExcel 
&lt;BR /&gt;java.lang.RuntimeException: Not implemented yet 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getNameXPtg(XSSFEvaluationWorkbook.java:105) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:916) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:556) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:427) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:266) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1117) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1077) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1064) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1424) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:1524) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:1508) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1465) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1445) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1566) 
&lt;BR /&gt; at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:174) 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:394) 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:368) 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook.getFormulaTokens(XSSFEvaluationWorkbook.java:146) 
&lt;BR /&gt; at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:277) 
&lt;BR /&gt; at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:221) 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCellValue(XSSFFormulaEvaluator.java:257) 
&lt;BR /&gt; at org.apache.poi.xssf.usermodel.XSSFFormulaEvaluator.evaluateFormulaCell(XSSFFormulaEvaluator.java:150) 
&lt;BR /&gt; at org.apache.poi.ss.usermodel.DataFormatter.formatCellValue(DataFormatter.java:588) 
&lt;BR /&gt; at edw.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.tFileInputExcelProcess(ShadowFileInputToDelimitedOutput.java:1087) 
&lt;BR /&gt; at edw.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.runJobInTOS(ShadowFileInputToDelimitedOutput.java:1659) 
&lt;BR /&gt; at edw.shadowfileinputtodelimitedoutput_0_1.ShadowFileInputToDelimitedOutput.main(ShadowFileInputToDelimitedOutput.java:1551) 
&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.repository.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:385) 
&lt;BR /&gt;org.talend.repository.ui.wizards.metadata.connection.files.excel.ExcelFileStep2Form$PreviewProcessor.nonUIProcessInThread(ExcelFileStep2Form.java:969) 
&lt;BR /&gt;org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)</description>
      <pubDate>Fri, 16 Mar 2012 22:04:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/xlsx-file-tFileInputExcel-java-lang-RuntimeException-Not/m-p/2356231#M121805</guid>
      <dc:creator>_AnonymousUser</dc:creator>
      <dc:date>2012-03-16T22:04:16Z</dc:date>
    </item>
    <item>
      <title>Re: xlsx file: tFileInputExcel java.lang.RuntimeException: Not implemented</title>
      <link>https://community.qlik.com/t5/Talend-Studio/xlsx-file-tFileInputExcel-java-lang-RuntimeException-Not/m-p/2356232#M121806</link>
      <description>Hi
&lt;BR /&gt;I have reproduced this issue.
&lt;BR /&gt;You can report it on 
&lt;A href="http://jira.talendforge.org/secure/Dashboard.jspa" target="_blank" rel="nofollow noopener noreferrer"&gt;BugTracker&lt;/A&gt;.
&lt;BR /&gt;Regards,
&lt;BR /&gt;Pedro</description>
      <pubDate>Mon, 19 Mar 2012 03:31:18 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/xlsx-file-tFileInputExcel-java-lang-RuntimeException-Not/m-p/2356232#M121806</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2012-03-19T03:31:18Z</dc:date>
    </item>
  </channel>
</rss>

