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

104 阅读 0 评论 69 点赞

我是靠谱客的博主真实秀发，这篇文章主要介绍python 生成多sheet的excel，并在sheet页插入图片，现在分享给大家，希望可以做个参考。

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
# -*- 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 !')