Unable to read "inline" values
Created originally on Bitbucket by epost
As far as I can tell, the code does not support reading data from cells if the "inlineStr" option is used in the underlying xml. For example, if the xml for the cell looks something like this:
4953.25
...instead of this (which is more typical):
4953.25
This may not be the most proper way to fix it, but I was able to patch this for myself (I'm using v1.5.6) by adding this if-statement to the fast_parse method in reader/worksheet.py (the first line is existing code, line 86 in v1.5.6, or line 106 in v.1.5.7):
{{{ #!python value = element.findtext('{http://schemas.openxmlformats.org/spreadsheetml/2006/main}v') if value is None and element.get('t') == 'inlineStr': value = element.findtext('{http://schemas.openxmlformats.org/spreadsheetml/2006/main}is/{http://schemas.openxmlformats.org/spreadsheetml/2006/main}t') }}}
Attachments: SafeQReport-XLSX-2013-09-30-13-08-00.xlsx