python - Pandas to_excel bad converting of special characters although print(df) shows them fine -

i've got standard script queries postgresql database, puts query pandas dataframe, , using:

writer = pd.excelwriter('somepath.xlsx', encoding='utf-8') df.to_excel(writer, 'sheet1') writer.save() 

i getting following:

openpyxl.utils.exceptions.illegalcharactererror

when out dataframe csv, can see characters wrong:

ksi｡ｯki should ksiĄŻki.

but console output od print(df) shows characters fine:

console output:

6  124842  5205298                         sŁawomir leŚniewski     

csv output:

6   124842  5205298 s｣awomir leｦniewski  

i've exported text such characters many times before, using same script.

any ideas?

wiki