0 votes
837 views

Dear openLCA Team,

I am getting error while exporting the results to excel (Error exporting results). I tried "direct calculation" and  I cannot export the results t the excel. However, when I create product system of the corresponding process, and export the results to the excel, it works.

Open Log:
31943469 Worker-32: Export... ERROR org.openlca.io.xls.results.system.ResultExport Error exporting results
java.lang.IllegalArgumentException: Invalid column index (16384). Allowable column range for EXCEL2007 is (0..16383) or ('A'..'XFD')
     at org.apache.poi.xssf.streaming.SXSSFRow.checkBounds(SXSSFRow.java:138)
     at org.apache.poi.xssf.streaming.SXSSFRow.createCell(SXSSFRow.java:118)
     at org.apache.poi.xssf.streaming.SXSSFRow.createCell(SXSSFRow.java:102)
     at org.openlca.io.xls.Excel.cell(Excel.java:66)
     at org.openlca.io.xls.Excel.cell(Excel.java:76)
     at org.openlca.io.xls.Excel.cell(Excel.java:72)
     at org.openlca.io.xls.results.CellWriter.cell(CellWriter.java:201)
     at org.openlca.io.xls.results.CellWriter.cell(CellWriter.java:167)
     at org.openlca.io.xls.results.CellWriter.processCol(CellWriter.java:45)
     at org.openlca.io.xls.results.system.ProcessFlowContributionSheet.subHeaderCol(ProcessFlowContributionSheet.java:48)
     at org.openlca.io.xls.results.system.ProcessFlowContributionSheet.subHeaderCol(ProcessFlowContributionSheet.java:1)
     at org.openlca.io.xls.results.system.ContributionSheet.subHeaders(ContributionSheet.java:33)
     at org.openlca.io.xls.results.system.ProcessFlowContributionSheet.write(ProcessFlowContributionSheet.java:35)
     at org.openlca.io.xls.results.system.ProcessFlowContributionSheet.write(ProcessFlowContributionSheet.java:20)
     at org.openlca.io.xls.results.system.ResultExport.writeContributionSheets(ResultExport.java:86)
     at org.openlca.io.xls.results.system.ResultExport.run(ResultExport.java:70)
     at org.openlca.app.WrappedJob.run(WrappedJob.java:30)
     at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)

in openLCA by (120 points)

1 Answer

0 votes
by (113k points)
Hi Gianmarco,

there is already another post for the same topic - if the product system needs more columns than excel permits this causes of course issues. However, it is indeed, as you say, a bug in the direct calculation as this produces the error also for systems that are not exceeding excel's capacity when calculated via the product system. We will fix this, thank you for reporting it.

Best wishes,

Andreas
by (110 points)
Hi Gianmarco,

Has a solution to this issue been developed? I have OpenLCA 1.10.3 and I'm getting the same error message as the user above. I'm not seeing another post with a resolution but it there is one can you point me in the right direction?
...