做公司内部系统时,经常会遇到做表格数据的导出,表格导出很好实现,但是要实现带图片的导出就有点困难,下面楼主我分享一下自己写的脚本。
导出数据里面需要包含图片连接,导出时会自动下载,并且保存到图片。
需要导出的数据是 export_items,大家应该换成自己对应的数据源
head_filed 是 输出表格的表头字段哦
import xlsxwriter,os
from datetime import datetime
from io import BytesIO
from urllib.request import urlopen
def exportUnfishImgTask(head_dict,boday_items,path):
if not os.path.exists(path):
os.makedirs(path)
filename = "batchExport-{0}.xls".format(datetime.strftime(datetime.now(), "%Y%m%d%H%M%S"))
workbook = xlsxwriter.Workbook(os.path.join(path,filename))
worksheet = workbook.add_worksheet()
worksheet.write(0, 0, "IMG")
worksheet.set_column(0, 0, 40)
for num, filed in head_dict.items():
worksheet.write(0, num + 1, filed)
worksheet.set_column(0, num + 1, 40)
for i in range(len(boday_items)):
worksheet.