关注【软件测试小助手】,知识分享更全哦~
常用知识点:
# 创建一个excel表格
wb = openpyxl.Workbook()
# 给表格添加sheet名称
wb.create_sheet(index=0, title='test1')
# 保存表格
wb.save('test_openpyxl.xlsx')
1、读取微博爬取的内容写到表格
# 获取微博热搜内容
def get_text():
list_n = ['排行']
list_r = ['热搜名']
url = 'https://s.weibo.com/top/summary'
header = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 '
'(KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36'
}
response = requests.get(url=url, headers=header)
if response.status_code == 200: #判断接口请求是否正确
html = etree.HTML(requests.get(url, headers=header).text) # 构造XPath解析对象
hot_search_name = html.xpath('//td[@class="td-02"]/a/text()') # 热搜名 字符串列表
hot_search_rank