问题描述: 2021年7月18日23:26:38, 爬取 https://www.lagou.com/lbs/getAllCitySearchLabels.json 的JSON 数据,并写入 xls 文件,稍微设置一点样式。
# -*- coding=utf-8 -*-
import json
import urllib.request
import jsonpath
import xlwt
class GetCity(object):
def __init__(self, url):
self.url = url
self.header = {
"user-agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36",
"cookie": "user_trace_token=20210628135428-88d8073e-3041-4dfc-a8de-3bded87470d1;"
}
def get_city(self):
req = urllib.request.Request(self.url, headers=self.header)
resp = urllib.request.urlopen(req)
# print(resp.read().decode('utf-8'))
# 把 JSON 格式转化成字符串
json_resp = json.loads(resp.read())
# print(json_resp)
self.write_xls(json_resp)
def write_xls(self