|
在excel 中 图形为chart **的形式存在，图像以picture **的形式存在，则只取shape名称为chart的导入到WORD，使用docx 模块写入WORD
需要导入from PIL import ImageGrab, Image 用 pip pillow安装
from PIL import ImageGrab, Image #pip pillow
import docx
from docx.shared import Inches
from docx import Document
import time
import win32com.client as win32
import os
myDocument = Document()
chartlocation = ['N20:Z50', 'A20:M50', 'A53:M83',
'N53:Z83', 'A86:M116', 'N86:Z116', 'A119:M149']
# 循环处理每个截图区域
# 能把所有图片按原图象素导出来
excel = win32.gencache.EnsureDispatch('Excel.Application')
excel.Visible = True #可视化
excel.DisplayAlerts = False #是否显示警告
workbook = excel.Workbooks.Open(os.path.join(os.getcwd(),'2020年公司经营对比表.xlsx'))
for sheet in workbook.Worksheets:
if sheet.Name=='集团合计':
for i, shape in enumerate(sheet.Shapes):
print(sheet.Name,shape.Name)
if shape.Name.startswith('Chart 7'): # 'Picture'为图，Chart 为图形
shape.Copy()
image = ImageGrab.grabclipboard()
image.save('temp{}.jpg'.format(i+1), 'jpeg')
#
#
time.sleep(1.5)
#print(type(image))
myDocument.add_paragraph('第{}张图'.format(i+1))
myDocument.add_picture('temp{}.jpg'.format(i+1), width=Inches(6.0))
excel.Quit()
myDocument.save('out.docx')
|