Error occurs while exporting results to excel

Question

Dear openLCA Team,

I am getting error while exporting the results to excel (Error exporting results).

I start getting this error after creating global parameters but couldn't really understand the reason behind it. 

I tried "direct calculation" and in this case 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. Similarly, when I save as LCI result, then I can export it.

Is there any limitations of using direct calculations while having global parameters?

Time	Thread	Level	Category	Message
398647	Worker-0: 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)

Thanks,

Berfin

Comments

I've the same problem but also with the LCI result way. The only way for me is to create a product system. I cannot understand. How can I fix this?

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)

Answer 1

I think this is not related to the parameter directly, but to that the system is beyond excel's maximum columns capacity

Invalid column index (16384). Allowable column range for EXCEL2007 is (0..16383)

It is of course not perfect that the application does not catch this before attempting to write the excel, and we will address this in future versions. Thank you therefore for spotting and reporting it!

Comments

Is there allready a solution for this error?