Search code examples
pythonxlrd

XLRD rendering the wrong data while iterating the cellls having True/False and Percentage value

When Cell contains True it returns 1 and if contain False it returns 0.

Also if 80% are getting rendered as .8

I am confused now do not know where to look up at.

Solution

  • Well i think the problem is with file . I think you should check it with the file.

    I have the same issue when the xls file with True and False data created using openofffice and libra office return 0 and 1.

    I noticed while iterating the file with xlrd and when i create a file microsoft office .. The xlrd was sorking perfectly fine .. so please check it.