Revision history [back]

Hi friends,

I am trying to set up Python to read the "Branch ID" that I have typed into an Excel sheet. Let's say that my branch ID is R3, and I have simply typed R3 as it is in the Excel cell, without quotes or whatever.

Python reads it like [u'R3'].

I am using excelpy (book.get_range), not xlrd, but I remember having had this problem before with XLRD too.

I want Python to read it like ["R3"], I mean, I want it to read it as a string.

Please, does anyone know how to get rid of the u character ?

Thanks,

Andre

Hi friends,

I am trying to set up Python to read the "Branch ID" that I have typed into an Excel sheet. Let's say that my branch ID is R3, and I have simply typed R3 as it is in the Excel cell, without quotes or whatever.

Python reads it like [u'R3'].

I am using excelpy (book.get_range), not xlrd, but I remember having had this problem before with XLRD too.

I want Python to read it like ["R3"], I mean, I want it to read it as a string.

Please, does anyone know how to get rid of the u character ?

Thanks,

Andre