how to put encoding on xlsxwriter with python

Question

I want to write to excel files from textfiles and have centimeter square string in it like this picture

and when i run the the code it shows error like this

So i put an encoding but still not working like this

spamReader = csv.reader(open(filename, 'rb'), delimiter=';',quotechar='"')
workbook = xlsxwriter.Workbook(filename[:-4] + '.xlsx')
workbook.encoding="latin1"
sheet = workbook.add_worksheet('Original data')

Thanks for advance

Answer 1

sheet.write(rowx, colx, value.decode('latin1'))