ods file generate by pyexcel-ods failed to read

[JayHsuEgg]

Hi Miachm,

Lately I'm trying to use pyexel-ods to generate ods file, and use java SODS tool to read it.

However, I'm facing problem with below error message :
// ------------------------------------------------------- //
Exception in thread "main" java.lang.IndexOutOfBoundsException: Range goes out of
bounds: (end_of_range: 1, maxcolumns in sheet: 0
at com.github.miachm.sods.Range.(Range.java:31)
at com.github.miachm.sods.Sheet.getRange(Sheet.java:279)
at com.github.miachm.sods.Sheet.getRange(Sheet.java:250)
at com.github.miachm.sods.OdsReader.processCells(OdsReader.java:437)
at com.github.miachm.sods.OdsReader.processTable(OdsReader.java:330)
at com.github.miachm.sods.OdsReader.processSpreadsheet(OdsReader.java:262)
at com.github.miachm.sods.OdsReader.iterateFilesEntries(OdsReader.java:255)
at com.github.miachm.sods.OdsReader.processContent(OdsReader.java:80)
at com.github.miachm.sods.OdsReader.load(OdsReader.java:46)
at com.github.miachm.sods.OdsReader.load(OdsReader.java:38)
at com.github.miachm.sods.SpreadSheet.(SpreadSheet.java:52)
at com.github.miachm.sods.SpreadSheet.(SpreadSheet.java:39)
at BasicUsage.main(BasicUsage.java:17)
// ------------------------------------------------------- //

// ----------------------- pyexcel-ods script generate ods file ------------------------- //
from collections import OrderedDict
from pyexcel_ods import save_data

    data = OrderedDict() # from collections import OrderedDict
    data.update({"Sheet 1": [[1, 2, 3], [4, 5, 6]]})
    data.update({"Sheet 2": [["row 1", "row 2", "row 3"]]})
    save_data("Jay.ods", data)

// ---------------------------------------------------------------------------------------- //

Attachment will be the ods file caused above issue

Jay.ods

[github-actions]

Thanks for your report! Please ensure you have provided enough info in order to recreate the issue, including the problematic ODS File.' first issue

[miachm]

The generated ODS file is not declaring the table:table-column tag in its XML. Which it's odd but seems an acceptable behaviour.

It should be solved with a simple if which "inserts" the unexpected columns.

[JayHsuEgg]

Hi Miachm,

It worked! I really appreciated your help!
Thank you~

Sincerely
Jay