# 導(dǎo)入模塊
import xlrd
from xlutils.copy import copy
import xlwt
import itchat
import datetime
import time
# 使用手機(jī)掃描二維碼登錄微信
def WeChatLogin():
 itchat.login()
# 給指定好友發(fā)送指定內(nèi)容的消息
def SendAMassage(friend, message):
 users = itchat.search_friends(name=friend)
 userName = users[0]['UserName']
 itchat.send(message, toUserName = userName)
# 按照指定格式修改excel表格內(nèi)容
def ModifyContent(row,col,content,sheet,new_remindbook,path,style):
 # 獲取工作表內(nèi)容
 new_sheet = new_remindbook.get_sheet(0)
 # 寫(xiě)入數(shù)據(jù)
 new_sheet.write(row,col,content,style)
 # 保存文件
 new_remindbook.save(path)
# 判斷提醒是否過(guò)期
def Overdue(nowtime,deadtime):
 if deadtime<nowtime:
 return True
 else:
 return False
# 程序運(yùn)行主體
if __name__=='__main__':
 # 首次執(zhí)行標(biāo)志
 first_exec = True
 # 微信登錄
 WeChatLogin()
 # 指定微信消息推送好友
 friend = '君以沫'
 # 備忘本記錄文件地址
 path = r'.記事本.et'
 # 掃描備忘本記錄
 while True:
 # 文件占用標(biāo)志
 occupy = False
 # 打開(kāi)excel文件，獲取文件屬性信息
 remindbook = xlrd.open_workbook(path,formatting_info=True)
 sheet = remindbook.sheet_by_index(0)
 nrows=sheet.nrows
 # 建立副本
 new_remindbook=copy(remindbook)
 # 初始化事項(xiàng)序號(hào)
 mark = 1
 # 初始化message信息
 message='以下事項(xiàng)未辦結(jié)：'
 # 執(zhí)行一次備忘本掃描
 for i in range(2, nrows):
 # 如果已辦結(jié)事項(xiàng)或者空事項(xiàng)，直接跳過(guò)
 if sheet.cell(i,3).value=='是' or sheet.cell(i,2).value=='':
 continue
 # 獲取事項(xiàng)截止時(shí)間
 deadtime = xlrd.xldate.xldate_as_datetime(sheet.cell(i,2).value, 0)
 deadhour = deadtime.strftime('%H:%M')
 # 獲取當(dāng)前時(shí)間
 nowtime = datetime.datetime.now()
 nowhour=nowtime.strftime("%H:%M")
 # 如果過(guò)期，則將過(guò)期標(biāo)志設(shè)置為是
 if Overdue(nowtime,deadtime):
 # style0
 style0 = xlwt.XFStyle()
 # 設(shè)置單元格背景顏色
 pattern= xlwt.Pattern()
 pattern.pattern=1
 pattern.pattern_fore_colour=22
 style0.pattern=pattern
 # 字體設(shè)置
 font = xlwt.Font()
 font.name = '仿宋_GB2312'
 font.colour_index = 1
 font.height =280
 style0.font = font
 # 邊框設(shè)置
 borders = xlwt.Borders()
 borders.left = xlwt.Borders.THIN
 borders.left = xlwt.Borders.THIN
 borders.right = xlwt.Borders.THIN
 borders.top = xlwt.Borders.THIN
 borders.bottom = xlwt.Borders.THIN
 style0.borders = borders
 # 為過(guò)期事項(xiàng)添加背景色（按指定格式重填）
 try:
 ModifyContent(i,1,sheet.cell(i,1).value,sheet,new_remindbook,path,style0)
 except:
 occupy = True
 print('文件占用中，休息60s...')
 time.sleep(6)
 break
 # style
 style = xlwt.XFStyle()
 # 設(shè)置單元格字體、顏色、字號(hào)
 font = xlwt.Font()
 font.name = '仿宋_GB2312'
 font.colour_index = 0
 font.height =280
 font.bold = False 
 style.font = font
 # 設(shè)置單元格對(duì)齊方式
 alig = xlwt.Alignment()
 alig.horz = xlwt.Alignment.HORZ_CENTER
 alig.vert = xlwt.Alignment.VERT_CENTER
 style.alignment = alig
 # 邊框設(shè)置
 borders = xlwt.Borders()
 borders.left = xlwt.Borders.THIN
 borders.left = xlwt.Borders.THIN
 borders.right = xlwt.Borders.THIN
 borders.top = xlwt.Borders.THIN
 borders.bottom = xlwt.Borders.THIN
 style.borders = borders
 # 按照指定格式寫(xiě)入數(shù)據(jù)
 try:
 ModifyContent(i,3,'是',sheet,new_remindbook,path,style)
 except:
 occupy = True
 print('文件占用中，休息60s...')
 time.sleep(6)
 break
 # 未過(guò)期事項(xiàng)，添加到提醒信息中
 else:
 # 截止時(shí)間單獨(dú)事項(xiàng)提醒
 if deadhour == nowhour:
 SendAMassage(friend, sheet.cell(i,1).value)
 message = message+'
'+'['+str(mark)+']'+sheet.cell(i,1).value
 mark=mark+1
 # 如果沒(méi)有被占用
 if not(occupy):
 # 沒(méi)有未辦結(jié)事項(xiàng)，結(jié)束循環(huán)
 if len(message)<=8:
 print('here')
 break
 # 首次運(yùn)行消息提醒
 if first_exec:
 SendAMassage(friend, message)
 print(message)
 first_exec = False
 release = False
 # 如果是以下時(shí)點(diǎn)，則推送微信消息提醒
 if nowhour in ['08:00','10:00','12:00','14:00','16:00']:
 SendAMassage(friend, message)
 # 其他時(shí)點(diǎn)
 else:
 print('當(dāng)前時(shí)間：'+ nowtime.strftime("%Y%m%d %H:%M:%S")+' '+'休息30秒...' )
 # 半點(diǎn)整點(diǎn)打印未辦結(jié)事項(xiàng)
 if nowhour[3:] in ['30','00']:
 print(message)
 time.sleep(30)
 # 所有事項(xiàng)已辦結(jié)
 message='所有事項(xiàng)已辦結(jié)。'
 SendAMassage(friend, message)
 print(message)
 # 退出微信登錄
 itchat.logout()