0 votes
87 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 (49.9k 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 (100 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!
...