python 3.7.1 发请求--＞析响应内容--＞将内容写入到excle文件中。

import json
import urllib.request
import urllib.parse
from openpyxl import Workbook

list_data = []

def http_request(url, page_no):
    send_headers = {
        # "Accept": "application/json, text/javascript, */*; q=0.01",
        # "Accept-Encoding": "gzip, deflate",
        # "Accept-Language": "zh-CN,zh;q=0.9",
        # "Connection": "keep-alive",
        # "Host": "10.0.18.93:8105",
        # "Origin": "http://10.0.18.93:8105",
        # "Referer": "http://10.0.18.93:8105/listing?caseState=-1",
        # "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.122 Safari/537.36",
        # "X-Requested-With": "XMLHttpRequest",
        # "Content-Length":182
        "Content-Type": "application/x-www-form-urlencoded;charset=UTF-8",
        "Cookie": "JSESSIONID=E4EFD9929BC45534F2896A5C53B677A9"
    }

    post_para = {
        "caseName": "",
        "caseNo": "",
        "startTime": "",
        "endTime": "",
        "caseDepartment": "",
        "searchContent": "",
        "dealUser": "",
        "status": "",
        "sourceList": "",
        "caseCharacter": "",
        "isPZ": "",
        "pageNo": page_no,
        "pageSize": 10,
        "isQueryDocInfo": True,
        "isQueryUnderCase": True
    }

    # postData = urllib.urlencode(post_para)
    # print(post_para)
    # http = urllib3.PoolManager
    # resp_data = http.request("POST", url, json.dumps(post_para), send_headers)
    post_data = urllib.parse.urlencode(post_para).encode(encoding='utf-8')
    req = urllib.request.Request(url=url, data=post_data, headers=send_headers, method='POST')
    resp_data = urllib.request.urlopen(req).read()
    resp_data = resp_data.decode('utf8')
    # print(resp_data)
    content = json.loads(resp_data)
    # print(content['success'])
    if content['success']:
        # print(content['data'])
        for item in content['data']:
            # print(item)
            list_data.append(item)

def get_content():
    # print(len(list_data))
    list_all = []
    if len(list_data) > 0:
        for item in list_data:
            list = []
            list.append(item['caseNo'])
            list.append(item['caseName'])
            list.append(item['caseDep'])
            list.append(item['contactUser'])
            list.append(item['jscs'])
            list_all.append(list)
        # print(list_all)

    return list_all

# 导出数据
def export_data(list_case, dest_file):
    wb = Workbook()
    ws = wb.active
    ws.title = '信息'
    for c in list_case:
        ws.append(c)
    wb.save(dest_file)

def main():
    for index in range(1, 25):
        http_request('http://10.0.18.93:8105/caseInfo/caseInfoList', index)

    content = get_content()
    dest_filename = 'D:\\测试信息.xlsx'
    export_data(content, dest_filename)

if __name__ == '__main__':
    main()