import requests
import json
from openpyxl import Workbook,load_workbook


wb = load_workbook('7.24.xlsx')
sheet1 = wb.get_sheet_by_name('Sheet1')
i=0
url = 'https://afsvc.jd.com/sub_afs/afsAllList/queryAfsList'
headers = {
    'cookie': '2DE6H4VGZN23TBDTMXNB6LAX3DVYSYX5UYRJYGNNW4FAJPUY6AGP6SOOKOESJACJONJD3RUR5KFAJHI6FMM4KTUFDWGIXT3QW2DSBMUUV3RSCVENN5BRI5KQMBHTUSES55MWARVOC2SKY5BQ; __USE_NEW_PAGEFRAME__=false; 3AB9D23F7A4B3C9B=7WFZPC67ITE62ITUDSDDI3N4XN6YA7M3BWFR7DA45O2CGVGIIZW5CJ7RK62AUNK5WSL2LJ6N3SH564LGLZ5KFHBIR4; style_flag=vcStyle; VC_INTEGRATION_JSESSIONID=b18e77cb-f760-411b-b872-57f0b05f5b8e; __jdc=82134214; b_belong=6RROAKWNA5W5DN6OGSGC7TZ6AM5BJG2AML2ENUAIJIQW63SY4JMNWGKKKFB4S2Z5FGHIKTSQT5BUQOPZ6HKVNQG7GXKL2S4ADXCYYYRJGRJDA57LXP2RHMWAXDGCNQIWQL55RZMCLOJPY4R4DMIOYOQTMMMV5TILOQOTJCMIQCB5XTRHTXK5GC454BDD42QV; __jda=82134214.1673238307473112822941.1673238307.1692859918.1692863439.36; adjustRemindMessage=1200000; __jdb=82134214.2.1673238307473112822941|36.1692863439',
    'referer': 'https://afsvc.jd.come',
    'user-agent': '*****',

}
for row in sheet1.iter_cols(min_col=5,max_col=5,min_row=2,max_row=20):
    for cell in row:
        i = i+1       
        dingdan = cell.value         
        data = {
            'orderId':f'{dingdan}',
            'afsApplyTimeBegin':'2023-05-25',
            'afsApplyTimeEnd':'2023-08-24',
            'length':'10',
            'page':'1',
            'sidx': '' ,
            'sord': ''
        }
        # print(data)
        print(f'第{i}个订单号')
        resp = requests.post(url ,headers=headers,data=data)
        resp_json = resp.json()
        resp_json_info = resp_json['jsonList']
        for afsApplyTime in resp_json_info:
            print(afsApplyTime['afsApplyTime'])
        
header = {
        #1.浏览器信息
        'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36 Edg/105.0.1343.27',
        #2.Referer：请求从哪里过来的，解决跨域的问题
        #3.主机的问题
        'Host': 'sina.com.cn',
        #4.浏览器的cookie信息
        'Cookie': 'Token=cCI6IkpXVCJ9.eyJ666zdWIYml3dSIsaW1pdHerectMiOiwiaWUzNDk4fQ.Cp_v9lLKU09lDgzv_QrLaduB7vNgzBY8g.CHAyfBCUD2323Ws8w%2FuLg; yk-dL=MTttOD56zk5MzM%3D'
        }

因为网站限制只有登录后才能查询信息，所以需要在headers里面含有登录信息，要不获取不到网页信息。

data = {
            'orderId':f'{dingdan}',###订单号从表格里面获取
            'afsApplyTimeBegin':'2023-05-25',
            'afsApplyTimeEnd':'2023-08-24',
            'length':'10',
            'page':'1',
            'sidx': '' ,
            'sord': ''
        }

修改data数据也可拿到不通订单号的信息，时间，不通页码等等。