使用python,处理JSON格式数据到Excel
上一篇 /
下一篇 2017-06-13 10:23:10
/ 个人分类:python
resultJson = json.loads(jsonStr)sqlList = resultJson["result"]
file = xlwt.Workbook()
ws = file.add_sheet('Result Sheet')
#添加title
ws.write(0, 1, "Server")
ws.write(0, 2, "Client")
ws.write(0, 3, "runSql")
beginRow = 0;
#循环将数据插入Excel
for i in range(0,len(sqlList)):
sqlResult = sqlList[i]
clientList = sqlResult["clients"]
sqlStr = sqlResult["sql"]
#合并单元格SQL
ws.write_merge(beginRow + 1,beginRow + len(clientList) , 0, 0, sqlStr)
#
for j in range(0,len(clientList)):
infoObject = clientList[j] ws.write(beginRow + j + 1, 1, infoObject["productDb"])
ws.write(beginRow + j + 1, 2, infoObject["client"]) ws.write(beginRow + j + 1, 3, infoObject["runsql"])
beginRow = beginRow + len(clientList)
file.save(os.path.abspath('.') + "\\"+"Result.xls")
收藏
举报
TAG:
Excel
Python
python