excel表格展示
import json
import xlwt
d = json.load(open("D:\\笔记\\22.txt", 'r',encoding="utf-8"))
# for item in d:
# print(item["_source"])
xls=xlwt.Workbook()
sht1 = xls.add_sheet("Sheet1")
#设置excel表头一行四列
sht1.write(0,0,"ipv4_addr")
sht1.write(0,1,"port_num")
sht1.write(0,2,"application_protocol")
sht1.write(0,3,"domain_url")
#循环填充表格数据
line=1
for item in d:
sht1.write(line,0,item["_source"]["ipv4_addr"])
sht1.write(line,1,item["_source"]["port_num"])
sht1.write(line,2,item["_source"]["application_protocol"])
sht1.write(line,3,item["_source"]["domain_url"])
line=line+1
xls.save(r"D:\\ab.xls")
View Code
[
{
"_index" : "common_asset_info_20220114",
"_type" : "_doc",
"_id" : "175.222.248.145-222-h4ujgn2.cachenode.cn",
"_score" : 1.0,
"_source" : {
"ipv4_addr" : "175.222.248.145",
"application_protocol" : "http",
"domain_url" : "h4ujgn2.cachenode.cn",
"port_num" : 222
}
},
{
"_index" : "common_asset_info_20220114",
"_type" : "_doc",
"_id" : "222.2253-9785-lh47ff3.cachenode.cn",
"_score" : 1.0,
"_source" : {
"ipv4_addr" : "222.243.22.53",
"application_protocol" : "http",
"domain_url" : "lh47ff3.cachenode.cn",
"port_num" : 9785
}
}
]
json内容
通过python解析json内容并把相关数据生成一个新的excel文件