Python Openpyxl Language Russian

Question

I have a problem when I pull and print the Russian-language strings

Use Python 2.7 and Lib Openpyxl

Code use is :

workbook = load_workbook(filename ='sample.xlsx')
first_sheet = workbook.get_sheet_names()[0]
worksheet = workbook.get_sheet_by_name(first_sheet)

ws = workbook.active

riga = 0;
id_cell = 0;
lenght_word = 0;

for row in worksheet.iter_rows():
    riga+=1
    id_cell=0;
    if riga > 4:
        for cell in row:
            id_cell+=1
            if id_cell == 3:
                lenght_word = cell.value
                print lenght_word
            if id_cell > 3:   
                try:
                    #print cell
                    str_lenght = len(cell.value)
                    print cell.value, str_lenght

Error generate when print return codecs.charmap_encode(input,errors,encoding_map)

thanks

use win7 and the format of STDOUT is cp850 – Bonni Mar 27 '17 at 08:52 — Bonni, Mar 27 '17 at 08:52

score 0 · Answer 1 · answered Mar 27 '17 at 08:22

0

The problem is with your print statement and Python 2. All non-numerical cell values are unicode so your code must manage the conversion from unicode to a suitable encoding for your system.

answered Mar 27 '17 at 08:22

Charlie Clark

18,477
4
49
55

But i use the code : stringa = cell.value stru = stringa.encode('utf-8') view a different string to original – Bonni Mar 27 '17 at 08:33
So what? When you read the value you will always get unicode. – Charlie Clark Mar 27 '17 at 09:01

Python Openpyxl Language Russian

1 Answers1