Python脚本
import pandas as pd
import json
from pywechat.WechatAuto import Contacts
friends_info=Contacts.get_friends_info()
friends_info=json.loads(friends_info)
nicknames=[dic.get('昵称') for dic in friends_info]
remarks=[dic.get('备注') for dic in friends_info]
wechatnums=[dic.get('微信号') for dic in friends_info]
friend_data={'昵称':nicknames,'备注':remarks,'微信号':wechatnums}
friend_data=pd.DataFrame(friend_data,index=range(1,len(nicknames)+1,1))
#这里的路径换成你自己新建的一个空白excel就行
friend_data.to_excel(r"C:\TMP.xlsx",index=False)
参考:
使用pywechat导出微信通讯录内所有好友信息至excel中
pywechat依赖微信Wechat.exe文件路径
手动添加
根据实际情况填写:
- wechat
- E:\E_Workspace\Sw Workspace\WeChart Workspace\WeChat Files\wxid_ose1chb3u0tk22
用命令行
setx wechat "c:\test";
NOTE: 根据实际情况填写路径