Skip to content

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

Created originally on Bitbucket by whitehat2k13 (whitehat2k13 NA)

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.

Attachments: output.xlsx

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information