爬取论坛标题存到Excel表格
import requestsfrom openpyxl import Workbook
wb = Workbook() #创建一个Excel文件
sheet = wb.active
url = 'https://club.coovm.com/forum-53-1.html'
spon = requests.get(url=url)
#print(spon.text) #获得HTML网页数据
#print(spon.content) #获得返回的数据（二进制）
from pyquery import PyQuery
doc = PyQuery(spon.text)
print(type(doc))
#print(doc)
#print(doc('#moderate .common a'))
for item in doc.items('#threadlisttableid .xst'):
print(item.text())
sheet.append()
wb.save( "测试2.xlsx")
页:
[1]