给微信好友批量发图片

import xlrd
import xlwt 
import sys,os
import itchat
import time

wk = xlrd.open_workbook(os.getcwd()+'\\好友名单1.xls')
sheet = wk.sheet_by_name('Sheet1')
R = sheet.nrows #行
print(str(R)+'行')
itchat.auto_login(hotReload=True) #热启动你的微信
for i in range(1,R):
    rnam=str(sheet.cell(i,2).value)
    #print(rnam)
    ff = itchat.search_friends(remarkName=rnam)
    #print(os.getcwd())
    f=os.getcwd()+'\\pic\\'+rnam+'.png'
    #print(ff)
    time.sleep(3)
    try:
        itchat.send_image(f,toUserName=ff[0]['UserName']) #如果是其他文件可以直接send_file
        print(str(i)+rnam+"_success")
    except:
        print(str(i)+rnam+"_fail")