0 votes
1.6k views

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?

TimeThreadLevelCategoryMessage
398647Worker-0: Export...ERRORorg.openlca.io.xls.results.system.ResultExportError 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

in openLCA by (130 points)
edited by
by (120 points)
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)

1 Answer

+1 vote
by (123k points)

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!

by (130 points)
Thanks for your answer!

Do you think running it through the Python inter-phase and export as CVS will work?
by (123k points)
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.
by (160 points)
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!
by (140 points)
Is there allready a solution for this error?
...