python截图识字并保存在xls表格中

准备：

　　1.库：keyboard, pillow, baidu-aip, xlwt

　　2.百度api： ai.baidu.com 注册并提供相关参数

 

代码：

import keyboard
from PIL import ImageGrab
import time
from aip import AipOcr
import xlwt

xls_path = r'C:\Users\Administrator\Desktop\test.xls'  #保存表格位置
table = xlwt.Workbook()
worksheet = table.add_sheet('sheet1')

# 调用百度AI识别文字
API_ID = "你的AppID"
API_KEY = "你的API Key"
SECRET_KEY = "你的Secret Key"
client = AipOcr(API_ID, API_KEY, SECRET_KEY)


def get_file_content(filepath):
    with open(filepath, 'rb') as fp:
        return fp.read()


# 01 开始截图
print("开始截图")
num = 0
while 1:
    keyboard.wait(hotkey='ctrl+alt+a')
    print('键盘按下了"ctrl+alt+a"')
    keyboard.wait('enter')
    print('键盘按下了"enter"')
    time.sleep(0.5)

    # 02 保存图片
    image = ImageGrab.grabclipboard()
    image.save('screen%s.png' % num)

    # 调用百度API文字识别
    res_image = get_file_content('screen%s.png'%num)
    text = client.basicAccurate(res_image)
    textList = text['words_result']
    print(textList)

    num1 = 0
    for i in textList:
        print(i['words'])
        worksheet.write(num, num1, i['words'])
        table.save(xls_path)
        num += 1

    num += 1

    print('截图结束')

 

心得

　　2020/1/13 在QQ登录状态下比较好用，缺点单独执行无截图区域显示