Python-Excel-06-插入图片

import os
import win32com
from win32com.client import constants as c  # 旨在直接使用VBA常数

current_address = os.path.abspath('.')excel_address = os.path.join(current_address, "插入图片.xlsx")
xl_app = win32com.client.gencache.EnsureDispatch("Excel.Application")  # 若想引用常数的话使用此法调用Excel

xl_app.Visible = False  # 是否显示Excel文件

wb = xl_app.Workbooks.Open(excel_address)
sht = wb.Worksheets(1)
sht.Name = "示例"

photo_address = os.path.join(current_address, "1.png")
print(photo_address)
if os.path.exists(photo_address):
   picture_left = sht.Cells(1, 1).Left
   picture_top = sht.Cells(1, 1).Top
   picture_width = sht.Cells(1, 1).Width * 5
   picture_height = sht.Cells(1, 1).Height * 10
   sht.Shapes.AddPicture(photo_address, 1, 1, picture_left, picture_top, picture_width, picture_height)wb.Save()
wb.Close()