1. """
    2. Excel批量到导出图片
    3. SS
    4. """
    7. from pymysql import TIME
    8. import win32com.client
    9. import time
    10. from datetime import datetime
    11. from PIL import Image, ImageGrab
    12. import os
    13. import win32gui
    14. from win32gui import *
    15. import win32gui
    16. import win32api
    19. def open_table():
    20.     xlapp = win32com.client.Dispatch("excel.Application")  # Excel
    21.     xlapp = win32com.client.Dispatch("ket.Application")  # WPS
    22.     xlapp.Visible = 1
    23.     xlapp.DisplayAlerts = False
    24.     ws = xlapp.ActiveSheet
    25.     ws = xlapp.Worksheets('111')
    26.     ws1 = xlapp.Worksheets.Add() # 添加 Sheet
    27.     xlScreen, xlPrinter = 1, 2
    28.     xlPicture, xlBitmap = -4147, 2
    29.     for i in range(1,3):
    30.         print(i)
    31.         range01 = "A"+str(i)
    32.         ws.Range(range01).Copy() # 复制单元格
    33.         ws1.paste
    34.         for aaa in ws1.Shapes:
    35.             aaa.ScaleHeight( 1, 1)
    36.             aaa.ScaleWidth( 1, 1)
    37.             for i11 in range(10):
    38.                 try:
    39.                     print(i11)
    40.                     aaa.CopyPicture(xlScreen, xlBitmap)
    41.                     break
    42.                 except Exception as e:
    43.                     time.sleep(0.5)
    44.                     print(e)
    45.             aaa.Delete()
    46.         save_pic(str(i))
    47.         clear_clipboard()
    51. def clear_clipboard():
    52.     from ctypes import windll
    53.     if windll.user32.OpenClipboard(None):  # 打开剪切板
    54.         windll.user32.EmptyClipboard()  # 清空剪切板
    55.         windll.user32.CloseClipboard()  # 关闭剪切板
    57. def save_pic(filename):
    58.     for i in range(10):
    59.         try:
    60.             # time.sleep(0.3)
    61.             # 图片过大，打开剪贴板过快
    62.             # OSError: failed to open clipboard
    63.             print("获取剪贴板次数："+str(i))
    64.             im = ImageGrab.grabclipboard()
    65.             break
    66.         except Exception as e:
    67.             time.sleep(0.5)
    68.             print(e)
    69.     a01 = 0
    70.     print(im.size)
    71.     filepath = r'C:\\Users\\ch\\Downloads\\SA8D9FS8AD90FSAD890F\\'+filename+'.png'
    72.     im.save(filepath)
    75. if __name__ == '__main__':
    76.     open_table()