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
运行成功