python 生成多sheet的excel，并在sheet页插入图片

# -*- coding: utf-8 -*-
import openpyxl
from openpyxl.drawing.image import Image
import xlsxwriter
#
pip install Pillow
excel_name = '统计结果.xlsx'
sheet_names = [
"个人账户收入明细表",
"个人账户收入台账信息表",
"个人账户支出明细表",
"个人账户支出台账信息表"
]
workbook = xlsxwriter.Workbook(excel_name)
for index, sheet_name in enumerate(sheet_names):
worksheet = workbook.add_worksheet(str(index) + sheet_name)
workbook.close()
print('Create a workbook and add worksheets complete !')
wb = openpyxl.load_workbook(excel_name)
for index, sheet_name in enumerate(sheet_names):
sheet = wb[str(index) + sheet_name]
img = openpyxl.drawing.image.Image(f'picture/{index}.png')
sheet.add_image(img, 'A1')
wb.save(excel_name)
print('save the workbook success !')

最后

以上就是真实秀发最近收集整理的关于python 生成多sheet的excel，并在sheet页插入图片的全部内容，更多相关python内容请搜索靠谱客的其他文章。