- 获取截图坐标 # left, top, right, bottom
![在这里插入图片描述](https://img-blog.csdnimg.cn/132ba782e9cc4b92a28612f01912bf77.png#pic_center)
from PIL import ImageGrab
import pyautogui
from openpyxl import load_workbook
from openpyxl.drawing.image import Image
import time
def GetIma():
print("------begin--------")
time.sleep(1)
ima = ImageGrab.grab(bbox=(805,237,1029,367))
ima.save("part1.png")
def save_img_to_excel(filename,by_col, to_col, ima1):
"""
:param filename: excel文件名
:param to_col: 存储列
:param content: 存储的图片
"""
wb = load_workbook(filename)
ws = wb.active
for num, val in enumerate(ws[by_col], start=1):
ws.add_image(img=Image(ima1), anchor=to_col+str(num))
wb.save(filename)
if __name__ == '__main__':
ima = GetIma()
save_img_to_excel("26.xlsx", "A", "B", "part1.png")