把excel数据写入到json文件

把excel数据写入到json文件

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

def ExcelJson():
    wb=openpyxl.load_workbook(r'D:\zhiang\项目\售前指标\os.xlsx')
    sheet=wb['sheet1']
    sku_id=[]
    sku_name=[]
    max_row=sheet.max_row
    for i in range(2,max_row+1):#
        id=sheet.cell(i,1).value
        name=sheet.cell(i,2).value
        #print (id,name)
        sku_id.append(id)
        sku_name.append(name)
        #print(sku_id,sku_name)

    f = open("sku.json", encoding='utf-8')
    setting = json.load(f)
    #print (setting)
    for i in range(2, max_row + 1):
        index=i-2
        setting['sku_id']=sku_id[index]
        setting['sku_name']=sku_name[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()


ExcelJson()