python中json嵌套文件进行解析,想要遍历打印输出数据并进行保存,但是现在只打印出一半为什么?分两个try是因为想着有两个json列表,分开会好一点,可以帮忙看看吗?
for i in json.loads(jobs['value']['fpmxxx']):
list=[]
list1=[]
list2=[]
list3=[]
for j in i['fpxx']: # list
s3 = j["mxxx"]
list1.append(s3)
for j in i['fpxx']: # dict
list2.append(j)
for k in list2:
if "mxxx" in k:
del k["mxxx"]
# #print(k)
list3.append(k)
list=list1+list3
for job in list:
# 要写入excel的数据
try:
FPZLMC = job['fpzlmc']
BZ = job['bz']
JYM = job['jym']
GFSBH = job['gfsbh']
GFMC = job['gfmc']
JSHJ = job['jshj']
print(FPZLMC,BZ,JYM,GFSBH,GFMC,JSHJ)
# 将数据写入到下一行
wb.cell(row=count, column=1, value=FPZLMC)
wb.cell(row=count, column=4, value=BZ)
wb.cell(row=count, column=7, value=JYM)
wb.cell(row=count, column=8, value=GFSBH)
wb.cell(row=count, column=9, value=GFMC)
wb.cell(row=count, column=13, value=JSHJ)
except Exception:
continue
count += 1
try:
MC = job['mc']
DJ = job['dj']
KPYF = job['kpyf']
KPRQ = job['kprq']
FPDM = job['fpdm']
FPHM = job['fphm']
JE = job['je']
print(MC,DJ,KPYF,KPRQ,FPDM,FPHM,JE)
wb.cell(row=count, column=2, value=MC)
wb.cell(row=count, column=3, value=DJ)
wb.cell(row=count, column=5, value=KPYF)
wb.cell(row=count, column=6, value=KPRQ)
wb.cell(row=count, column=10, value=FPDM)
wb.cell(row=count, column=11, value=FPHM)
wb.cell(row=count, column=12, value=JE)
except Exception:
continue
count += 1
ws.save('FP.xlsx')
出错了呗 所以只 打印了一半 你把try去掉看看呢