python 實現(xiàn)截圖自動存入Excel表

首先我先在桌面新建一個test.xls文件

import keyboard #監(jiān)聽按鍵庫

from PIL import ImageGrab #圖像處理庫

import time

from aip import AipOcr #pip install baidu_aip\

import xlwt

biao = xlwt.Workbook()

worksheet = biao.add_sheet('sheet1')

# print("開始截圖")

# 1. 截取圖片

num=0

while 1:

keyboard.wait(hotkey='ctrl+alt+a')

print("鍵盤按下了'ctrl+alt+a'")

keyboard.wait('enter')

print("鍵盤按下了'enter'")

# 模擬延遲，來解決grabclipboard函數(shù)的緩存問題（grabclipboard函數(shù)操作太快，它就會讀取上一次的內容）

time.sleep(0.1)

# 2. 保存圖片到電腦上

image = ImageGrab.grabclipboard()

image.save('screen%s.png'%(num))

# 3. 調用百度AI識別圖片內容

APP_ID = '你的APP_ID'

API_KEY = '你的API_KEY'

SECRET_KEY = '你的SECRET_KEY'

client = AipOcr(APP_ID, API_KEY, SECRET_KEY)

# 獲取圖片的二進制數(shù)據(jù)

def get_file_content(filePath):

with open(filePath, 'rb') as fp:

return fp.read()

image = get_file_content('screen%s.png'%(num))

""" 調用通用文字識別（高精度版） """

text = client.basicAccurate(image)

textList = text['words_result']

print(textList)

num1 = 0

for i in textList:

worksheet.write(num, num1, i['words'])

biao.save('C:\\Users\\mxy\\Desktop\\test.xls')

num1 += 1

num+=1

print("結束截圖")