擅长:python、mysql、java
<p>根据你的建议,我修改了代码。它是这样工作的,谢谢。如果有更好的方法,请告诉我</p>
<pre><code>import openpyxl
import PIL
from PIL import ImageGrab
from openpyxl.drawing.image import Image
import os
def pause():
programPause = input("Press <enter> key")
column_offset=10
row_offset=20
column_start=3
row_start=3
def screen_capture(a,b):
img=ImageGrab.grab()
img.save('test'+str(a+b)+'.jpg','JPEG')
wb = openpyxl.Workbook()
ws = wb.active
rowi=row_start
for x in range(1,3):
columnj = column_start
for y in range(1,2):
screen_capture(x,y)
img1=Image('test'+str(x+y)+'.jpg')
img1.anchor = ws.cell(row=rowi, column=columnj).coordinate
ws.add_image(img1)
columnj = columnj+column_offset
pause()
rowi=rowi+row_offset
wb.save('Save_test_data.xlsx')
wb.close()
for x in range(1,3):
for y in range(1,2):
os.remove('test'+str(x+y)+'.jpg')
</code></pre>