Python Forum
Problem with Polish characters in xlsx file - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Problem with Polish characters in xlsx file (/thread-14127.html)

Problem with Polish characters in xlsx file - Mikser - Nov-15-2018

I have got a problem with Polish characters in xlsx file(words do not have Polish letters that have disappeared in an unknown way), which I take from table. What am I doing wrong? 

import os
import cx_Oracle
import xlsxwriter

con = cx_Oracle.connect('user/password@SID')

cur = con.cursor()

custdata =[]


def main():


    L_sFilename ="List_PNA.xlsx"

    workbook = xlsxwriter.Workbook(L_sFilename)
    worksheet = workbook.add_worksheet()

    format = workbook.add_format({'bold': True, 'font_color': 'red'})
    format.set_font_name('Times New Roman')
    format.set_align('center')

    worksheet.write('A1','PNA',format)
    worksheet.set_column('A:A', 60)

    worksheet.write('B1','BOX',format)
    worksheet.set_column('B:B', 60)

    worksheet.write('C1','NAME',format)
    worksheet.set_column('C:C', 60)

    worksheet.write('D1','PO',format)
    worksheet.set_column('D:D', 60)

    worksheet.write('E1','STREET',format)
    worksheet.set_column('E:E', 60)

    worksheet.write('F1','NUMBERS',format)
    worksheet.set_column('F:F', 60)

    worksheet.write('G1','CITY',format)
    worksheet.set_column('G:G', 60)

    worksheet.write('H1','PROVINCE',format)
    worksheet.set_column('H:H', 60)

    worksheet.write('I1','DISTRICT',format)
    worksheet.set_column('I:I', 60)

    worksheet.write('J1','COMMUNE',format)
    worksheet.set_column('J:J', 60)

    format2 = workbook.add_format()
    format2.set_align('center')
    format2.set_font_color('black')
    format2.set_font_name('Times New Roman')


    L_sSelect ="""select * from my_xml_schema.LIST_PNA_TAB"""

    cur.arraysize = 100
    cur.execute(L_sSelect)


    for result in cur:
        custdata.append((result))

    cur.close()
    con.close()

    for r, row in enumerate(custdata,1):

        for c, col in enumerate(row):
            a=str(col)
            cell = unicode(a, errors='ignore')
            worksheet.write(r, c, cell,format2)
            #print " r= "+str(r) + " c= "+str(c) + " val= "+cell


    workbook.close()
    os.startfile(os.getcwd()+"\\"+L_sFilename)



if __name__ == "__main__":
    main()


RE: Problem with Polish characters in xlsx file - Gribouillis - Nov-15-2018

This looks like python 2 code. Are you still using python 2? The error comes probably from the unicode(a, errors='ignore') if it silently removes polish characters. It could probably be replaced by a.decode("some encoding") or codecs.decode(a, "some encoding")

RE: Problem with Polish characters in xlsx file - Mikser - Nov-18-2018

Yes, I have got a version 2.7.15. Your solutions doesn`t work.

RE: Problem with Polish characters in xlsx file - DeaD_EyE - Nov-18-2018

You're using a language, which is deprecated. The support of Python 2.7 ends in 2020.
With Python 3 you get better Unicode-Support (also for emoticons).
Try it with Python 3. If you still get the same results, something is wrong with the encoding. Fixing encoding errors is more guessing than knowing.

RE: Problem with Polish characters in xlsx file - Gribouillis - Nov-18-2018

Mikser Wrote:Yes, I have got a version 2.7.15.
I agree with DeaD_EyE, upgrade to python 3 first. Most python 2 encoding issues simply disappear by moving to python 3. It is a waste of time to solve them.