接口获取数据写入json文件

#-*-coding:utf-8-*-
import openpyxl
import json
import requests

def readExcel():
    wb=openpyxl.load_workbook(r'D:\ruanjian\learn\os\testcase\sku_3c_7_1105.xlsx')
    sheet=wb['sku_3c_7_1105(1)']
    max_row = sheet.max_row
    max_col = sheet.max_column
    sku_id = []
    sku_name = []
    erp_acct=[]
    data = {"skuIdArray": 1211}
    for i in range(2, max_row + 1):  #
        id = sheet.cell(i, 1).value
        name = sheet.cell(i, 2).value
        sku_id.append(id)
        sku_name.append(name)
        data["skuIdArray"] = id
        url = "http://11.130/test/skuCheck"
        response = requests.post(url, data=data)
        res = json.loads(response.text)
        re = json.loads(res['hits'][0])['saler']
        erp_acct.append(re)
        sheet.cell(i, max_col + 1, value=re)
    wb.save('sku_3c_7_11051.xlsx')

    f = open("sku.json", encoding='utf-8')
    setting = json.load(f)
    #print (setting)
    for j in range(2, max_row + 1):
        index=j-2
        setting['sku_id']=sku_id[index]
        setting['sku_name']=sku_name[index]
        setting['erp_acct']=erp_acct[index]
        with open('sku2.json', 'a',encoding="utf-8") as f1:
            content=json.dumps(setting, ensure_ascii=False)
            f1.write(content)
            f1.write(',')

    f1.close()


readExcel()