(python库）电子发票自动开票

import pyautogui
import time
import pypaperclip
import xlwings as xw

def Click(x,y,num):
    pyautogui.click(x,y,clicks=num,button='left')

def Back(num):
    for i in range(num):
        pyautogui.press('backspace')

def Write(name):
    pyperclip.copy(name)
    pyperclip.paste()
    
with xw.App(visible=False, add_book=False) as app:
    app.display_alerts=False
    app.screen_updating=False
    book=app.books.open("开票模板.xls")
    sht=book.sheets("sheet1")
    rows = sht.used_range.last_cell.row
    for i in range(rows):
        name=str(sht.range(i+2,1).value)
        numb=str(sht.range(i+2,2).value)

        #所有步骤都暂停1秒
        pyautogui.PAUSE=1

        #点击“复制开票”
        Click(x,y,1)

        #点击“上一个开票人”
        Click(x,y,2)

        #点击“账号”
        Click(x,y,1)

        #删除上个人的姓名
        Back(4)

        Write(name)

        #点击“税号”
        Click(x,y,1)

        #删除上个人的税号
        Back(19)

        Write(num)

        #点击“开具”
        Click(x,y,1)

        time.sleep(20)

        #点击“确定”
        Click(x,y,1)