Suspected Unicode problem when reading text from Excell

maxm maxm at normik.dk
Wed Sep 5 07:52:12 EDT 2001


I have the following piece of code that sort of works ok.

import win32com.client
xl=win32com.client.Dispatch("Excel.Application")
xl.Visible=1
wb=xl.Workbooks(1)
sh=wb.Worksheets(1)
for row in sh.UsedRange.Value:
    (type, question, options, answerText, beforePic,
     afterPic, misc1, misc2, misc3, misc4) = row
    print question, options, answerText

But when I run it I get the error:

  File "C:\div\uninstalled\python\excell\jensMarius.py", line 9, in ?
    print question, options, answerText
UnicodeError: ASCII encoding error: ordinal not in range(128)

If i do this:






More information about the Python-list mailing list