import json
import requests
import xlwings
if __name__=="__main__":
url="http://scxk.nmpa.gov.cn:81/xk/itownet/portalAction.do?method=getXkzsList"
data={
"page": 1,
"pageSize": 15,
"conditionType": 1
}
headers={
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36",
}
res=requests.post(url=url,data=data,headers=headers)
lst=res.json()['list']
xlApp=xlwings.App(visible=False,add_book=False)
wb=xlApp.books.add()
sh = wb.sheets.add('1-150')
line=2
sh.range("A1").value='企业名称'
sh.range("B1").value='许可证编号'
sh.range("C1").value='发证机关'
sh.range("D1").value='有效期至'
sh.range(
10.python 采集数据并保存至Excel
最新推荐文章于 2024-04-29 09:54:45 发布