Excel files with inlineStr cell types parsed as None instead of actual value in read only mode

Issue #386 resolved
whitehat2k13 NA created an issue

See https://github.com/kz26/PyExcelerate/issues/34#issuecomment-65230703 for reference.

Expected cell values should be "col1", "col2", "col3" but iterating over the row returns None, None, None instead.

Example file attached - works fine in Excel 2013.

See p1598 of the ECMA OOXML reference, Part 1, 4th Edition for correct inlineStr semantics.

Comments (8)

  1. CharlieC

    It's worth noting that the issue only affects workbooks opened with read_only=True. Unfortunately, inlineStr is one of the shittiest parts of the specification and can count as an optimisation artefact and one which we will probably never fully support. I can understand it's appeal for PyExcelerate and any other libraries that just want to stream but it does make interoperability a lot harder. It specifically makes lazy loading, as done in read-only mode, slower.

  2. Log in to comment