wb = load_workbook('./产品--模板.xlsx')
# print(wb.sheetnames)
cp0 = wb['size']
cp1 = wb['cp001']
for page in range(len(self.cplist)):
cp_sheet = wb.copy_worksheet(cp1)
cp_sheet.title = self.cplist[page]['b4']
for key, val in self.cplist[page].items():
cp_sheet[key] = val
#
# for image in cp1._images:
# print('image:',image)
# cp_sheet.add_image(image)
# wb.remove(cp1)
wb.save(f'./产品/产品列表.xlsx')
wb.close()
QMessageBox.information(self, '提示', "产品列表 生成完成!!!", QMessageBox.Ok)
pass
这里面:ad_image会报错,除了图片都没问题