mardi 4 août 2015

Python xlrd Exception: Unknown cell type 'n+'

I have a python script that downloads an xlsx file and parses the contents, however it's started failing at the line

 workbook = xlrd.open_workbook(fname)

with the error "Exception: Unknown cell type 'n+' in rowx=1 colx=4"

Can anyone point me in the right direction with regards to what the n+ cell type is or how to move past this error

Alternatively if anyone knows of a python module that will read an xlsx file without tripping over this cell value.

Cheers

-- EDIT --

After unzipping the file I found this in the xml of the worksheet

<c r="E2" t="n+"><v>18</v></c>



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire