Python unicode: how to test against unicode string

Question

I have a script like this:

#!/Python26/
# -*- coding: utf-8 -*-

import sys
import xlrd
import xlwt

argset = set(sys.argv[1:])

#----------- import ----------------
wb = xlrd.open_workbook("excelfile.xls")

#----------- script ----------------
#Get the first sheet either by name
sh = wb.sheet_by_name(u'Data')

hlo = []

for i in range(len(sh.col_values(8))):
   if sh.cell(i, 1).value in argset:
        if sh.cell(i, 8).value == '':
            continue
        hlo.append(sh.cell(i, 8).value)

excelfile.xls contains unicode strings and I want to test against these strings from command line:

C:\>python pythonscript.py päätyö
pythonscript.py:34: UnicodeWarning: Unicode equal comparison failed to convert both arguments to
icode - interpreting them as being unequal
  if sh.cell(i, 1).value in argset:

How should I modify my code for Unicode?

Vijay Mathew · Accepted Answer · 2009-11-30 07:32:28Z

4

Python has a sequence type called unicode which will be useful here. These links contain more information to help you regarding this:

Python Unicode HOWTO
Python built-in types (See section 6.6).
Unicode In Python, Completely Demystified

answered Nov 30, 2009 at 7:32

Vijay Mathew

27.3k4 gold badges66 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jrara Over a year ago

I found this, which solved the problem: stackoverflow.com/questions/846850/…

BajajG Over a year ago

The first link does not exist anymore!

Kelmer · Accepted Answer · 2010-10-22 05:03:08Z

1

Try encoding the Excel unicode to string using cp1252 (windows default unicode) and then testing. I know a lot of people don't recommend this, but this is what sometimes solve my problems.

Pseudo=> if sh.cell(i, 1).value.encode('cp1252') in argset: ...

Br.

answered Oct 22, 2010 at 5:03

Kelmer

513 bronze badges

Collectives™ on Stack Overflow

Python unicode: how to test against unicode string

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related