Python 脚本：获取活动列表并生成二维码

import requests
import openpyxl
from openpyxl import Workbook, load_workbook
import jsonpath
import json
import qrcode
from PIL import Image

df = load_workbook(r'F:\Users\Administrator\PycharmProjects\pythonProject\营销开放平台工作应用\ck.xlsx')
sheet = df.active
AN = sheet['B2'].value
CT = sheet['B3'].value

headers = {
    'Connection': 'keep-alive',
    'sec-ch-ua': '"Chromium";v="21", " Not;A Brand";v="99"',
    'sec-ch-ua-mobile': '?0',
    'Authorization': '%s' % AN,
    'Content-Type': 'application/json;charset=UTF-8',
    'Accept': 'application/json, text/plain, */*',
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36',
    'CSRF-TOKEN': '%s' % CT,
    'sec-ch-ua-platform': '"Windows"',
    'Origin': 'https://vop.95516.com',
    'Sec-Fetch-Site': 'same-origin',
    'Sec-Fetch-Mode': 'cors',
    'Sec-Fetch-Dest': 'empty',
    'Referer': 'https://vop.95516.com/',
    'Accept-Language': 'zh-CN,zh;q=0.9',
}

json_data = {
    'qActId': '',
    'qActNm': '',
    'qActTyp': '',
    'qActStat': '',
    'qActStartTm': '',
    'qActStartTm1': '',
    'qActEndTm': '',
    'qActEndTm1': '',
    'qOrgId': '',
    'qOrgNm': '',
    'qBusiOrgId': '',
    'qBusiOrgNm': '',
    'qUsingStat': '',
    'budgetCode': '',
    'qSource': '01',
    'qChannelId': '',
    'qRightsId': '',
    'createUserId': '',
    'qSyncKnowledgeStat': '',
    'currentPage': 1,
    'pageSize': 2,
}

response = requests.post('https://vop.95516.com/gateway/marketing/api/activity/getActiList', headers=headers, json=json_data)
json_str = response.json()

dict = {}
for i in json_str['data']:
    dict[i['actId']] = i['actNm']

wb = Workbook()
ws1 = wb.active
user = ['活动ID', '活动名称', '领取方式', '二维码']

n = 1
for i, l in dict.items():
    n += 1
    data = {
        'tmpTyp': '2',
        'tmpId': '',
        'tempTypeIdentity': '1',
        'actId':  '%s' % i,
        'areaCode': '1',
        'areaCodeList': [],
    }
    response = requests.post(
        'https://vop.95516.com/gateway/marketing/api/activity/showActiInfDetail',
        headers=headers,
        json=data,
    )
    response_json = response.json()
    show = jsonpath.jsonpath(response_json, '$.data.fieldList[10].value')[0]
    if show == '0':
        print(i, l, '手动领取')
        url = 'https://mall.95516.com/mobile/rncouponinfo/' + i
        filename = 'qrcode.png'
        img = qrcode.make(url)
        img.save(filename)
        img = Image.open('qrcode.png')
        img = img.resize((100, 100))
        ws1.add_image(img, anchor='C' + str(n))
        ws1.cell(row=n, column=1, value=l).number_format = '@'
        ws1.cell(row=n, column=2, value=i).number_format = '@'

wb.save(r'C:\Users\Administrator\Desktop\手动领券情况.xlsx')