xlwings库
- xlwings 可结合VBA实现对Excel编程,具有强大的数据输入分析能力和丰富的接口,再结合Pandas/Numpy/Matplotlib,能轻松应对Excel的数据处理工作。
xlwings库的安装
pip install xlwings
生成Excel文件并且写入数据
- 这里我用了一个爬虫获取了一份数据方便进行数据保存,网站是小米商城,
url:'https://app.mi.com/categotyAllListApi?page=0&categoryId=6&pageSize=30'
- 完整代码
import requests
import xlwings as xw
class XiaomiSpider(object):
def __init__(self):
self.url = 'https://app.mi.com/categotyAllListApi?page=0&categoryId=6&pageSize=30'
self.header = {
'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/93.0.4577.63 Safari/537.36'
}
self.wb = xw.Book()
self.sht = self.wb.sheets[0]
title = [['displayName', 'level1CategoryName', 'packageName']]
self.sht.range('a1').value = title
def get_soure(self, url):
res = requests.get(url, headers=self.header).json()
return res
def parse_html(self, html):
data_lst = []
for i in html['data']:
item = []
item.append(i['displayName'])
item.append(i['level1CategoryName'])
item.append('https://app.mi.com/details?id=' + i['packageName'])
data_lst.append(item)
print(data_lst)
self.sht.range('a2').value = data_lst
self.wb.save()
def main(self):
html = self.get_soure(self.url)
self.parse_html(html)
if __name__ == '__main__':
x = XiaomiSpider()
x.main()
- 效果展示
![请添加图片描述](https://i-blog.csdnimg.cn/blog_migrate/e3fb4a145ea915fb7ddc580f9ac8a87d.png)