(python库）利用wxauto微信群发通知

import xlwings as xw
from wxauto import *
import time
wx = WeChat()
with xw.App(visible=False,add_book=False) as app:
    app.display_alerts = False   
    app.screen_updating = False
    file=r"个税群发模板.xlsx"
    book= app.books.open(file)
    sheet=book.sheets[0]
    cell = sheet.used_range.last_cell
    rows = cell.row
    columns = cell.column    
    for i in range(2,rows+1):
        try:
            name=sheet.range(i,1).value
            message=sheet.range(i,1).value+sheet.range(i,2).value+sheet.range(i,3).value+",你本月应交个税："+str(sheet.range(i,4).value)
            wx.ChatWith(name) 
            wx.SendMsg(message) 
            time.sleep(1)