-1

I don't understand why xlrd is reading a cell with value u'' as containing some text. All throughout the column it reads empty cells as having text although a couple of times it recognises as them not having it.

If anyone has ever encountered this same problem it would help!

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Antonia Calvi
  • 127
  • 1
  • 3
  • Please, put some code or an example. We may help you more easily. – CLeo-Dev Jun 29 '17 at 13:50
  • You said that a couple of times, xlrd recognizes empty cells as being empty. What do you mean by that? It's normal for "empty" cells to have a value that is a string of length zero. – John Y Jun 30 '17 at 22:24

1 Answers1

0

for example: the value of u'asdf' is the same as just 'asdf' the u'' means, that the value type is of unicode

https://docs.python.org/2/howto/unicode.html (see at "The Unicode Type")

Does an error occur on your code, or did you just whitness this and could not find an explanation for it?

fmedv
  • 153
  • 1
  • 2
  • 12