#-*-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()
接口获取数据写入json文件
最新推荐文章于 2022-07-26 09:45:00 发布