Python：复制Excel范围并将源格式粘贴到outlook电子邮件正文

Question

我想复制Excel范围，并将源格式粘贴到outlook电子邮件正文中。然而，我不知道如何做到这一点

我的临时解决方案将excel范围导出为图像，并将其作为图像粘贴到电子邮件中。我想知道如何将源格式粘贴到outlook电子邮件正文上

excel = win32.gencache.EnsureDispatch('Excel.Application')

wb = excel.Workbooks.Open("testing.xlsx")
sheet = wb.Sheets['Sheet1']
copyrange = sheet.Range('A1:N9')
copyrange.CopyPicture(Appearance = 1, Format = 2)
ImageGrab.grabclipboard().save('image1.png')
sheet = wb.Sheets['Sheet2']
copyrange2 = sheet.Range('A1:M26')
copyrange2.CopyPicture(Appearance = 1, Format = 2)
ImageGrab.grabclipboard().save('image2.png')
excel.Quit()


# Create outlook email and insert Excel Content
html = """
    <img src={}></img>
    <br><br>
    <img src={}></img>

"""


outlook         = win32.Dispatch('outlook.application')
mail            = outlook.CreateItem(0)
mail.Subject    = 'Testing'
mail.HTMLBody   = html.format("image1.png","image2.png")
mail.Display()