Ошибка кодировки

import openpyxl
from openpyxl import Workbook
from openpyxl import load_workbook
from openpyxl.worksheet.table import Table, TableStyleInfo
import xml.etree.ElementTree as ET
 
 
wb = openpyxl.reader.excel.load_workbook(filename = 'Osnovnoy_PRAJS.xlsx')
wb.active = 0
sheet = wb.active 
sheet_ranges = wb['чаши']
 
test = str(sheet['A2'].value)
test_2 = str(sheet['B2'].value)
test_3 = str(sheet['C1'].value)
test_4 = str(sheet['C2'].value)
 
first = ET.Element('ValBowls')
first.set('price', 'first campfire bowl factory')
id_field = ET.SubElement(first, 'name')
id_field.text = test
id_field = ET.SubElement(first, 'diameter')
id_field.text = test_2
id_field = ET.SubElement(first, 'thickness')
id_field.text = test_3
id_field = ET.SubElement(first, 'value')
id_field.text = test_4
 
 
mydata = ET.tostring(first, encoding='unicode', method='xml')
myfile = open('test.xml', 'w')
myfile.write(mydata)

from openpyxl import load_workbook
w = load_workbook(filename='filename.xlsx', use_iterators=True)
sh = w.get_sheet_by_name('название_страницы'.decode('utf8'))

mydata = ET.tostring(first, encoding='windows-1252', method='xml').decode('utf-8')