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

Thanks for your answer!

Do you think running it through the Python inter-phase and export as CVS will work?

---

Yes that should work; you will need to write some code (I think, from memory now) to specify how the csv is structured, but there you do not have this column limitation of course.

---

Hello,

I am also trying to export my results to excel but I get the same error message. Is there a way to export the results without using Python?

Thanks!

---

Is there allready a solution for this error?