- edited description
Excel files with inlineStr cell types parsed as None instead of actual value in read only mode
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)
-
-
- edited description
-
- changed title to Excel files with inlineStr cell types parsed as None instead of actual value in read only mode
-
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. -
Issue
#388was marked as a duplicate of this issue. -
- removed version
Removing version: 2.1.x (automated comment)
-
- changed status to resolved
Complete support for cells with inline strings in read-only mode. Resolves
#386.→ <<cset cdf7a3aacfa7>>
-
Great to see that this one has already been fixed!
I ran into it with v2.3.4 while trying to read a giganterific sheet written with
xlsxwriter
inconstant_memory
mode. (@CharlieC had suggested usingxlsxwriter
as a workaround on#196.) - Log in to comment