AttributeError: ‘ElementTree‘ object has no attribute ‘getiterator‘

Python版本号与IDE

1、Python3.10

2、Pycharm

代码

import os
import xlrd
import xlwt

path = r'E:\Python_Project\Sales\销售表'
lst_title = ['店铺', '品牌', '型号', '数量']

nwb = xlwt.Workbook('utf-8')
nws = nwb.add_sheet('汇总结果')

row_num = 0

for i in range(0, len(lst_title)):
    nws.write(0, i, lst_title[i])

files = os.listdir(path)
print(files)
for file in files:
    print(file)
    wb = xlrd.open_workbook('销售表/' + file)
    for ws in wb.sheets():
        for t, n in tuple(ws.get_rows())[1:]:
            tup = (file.split('.')[0], ws.name, t.value, n.value)
            row_num = row_num + 1
            for num in range(0, 4):
                nws.write(row_num, num, tup[num])
nwb.save('测试.xls')

报错

AttributeError: ‘ElementTree‘ object has no attribute ‘getiterator‘

原因

xml.etree.ElementTree.Element.getiterator()

已在Python 3.9中删除

解决办法

打开运行框里报错的最下面一个红色的链接，就是当前环境出错的包

进去搜索‘getiterator’

修改为‘iter’

保存后退出

再运行就能解决

D:\Aconda\envs\DataManagement\python.exe E:/Python_Project/DEMO/DEMO.py
运行成功