python图形化编辑word_python 将excel获取的图表直接写入WORD，修改为上下型环绕

[Python] 纯文本查看 复制代码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 = False #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'): # '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))

#myDocument.add_picture(image, width=Inches(6.0))

excel.Quit()

myDocument.save('out.docx')