java解析json格式的文件，Python對json數據的操作（香煙示例）

網上文章很多，也很簡單，今天順便備忘錄一下，是想把所有香煙的價格做一個報表，因為訂煙網站沒有導出報表的功能，所以就只能從他的源碼來分析了，查看之后還是json格式，那就更方便了

思路很簡單，把香煙的json數據保存到文本，通過讀文本，寫入到報表里面，更多報表操作請查看：Python對Excel的操作

import json
import openpyxl
import osdef loadJson(fname):with open(fname,'r',encoding='UTF-8') as f:load_f=json.load(f)return load_fdef loadXlsx(fname):if not os.path.isfile(fname):wb=openpyxl.Workbook()wb.save(fname)else:passwb=openpyxl.load_workbook(fname)return wbif __name__=='__main__':tobacco_infos=loadJson('tobacco.txt')xlsxName='smoke.xlsx'wb=loadXlsx(xlsxName)sheet=wb[wb.sheetnames[0]]sheet.cell(row=1,column=1).value='序號'sheet.cell(row=1,column=2).value='條碼'sheet.cell(row=1,column=3).value='煙名'sheet.cell(row=1,column=4).value='批發價'sheet.cell(row=1,column=5).value='零售指導價'i=2for t in tobacco_infos:sheet.cell(row=i,column=1).value=i-1;sheet.cell(row=i,column=2).value=t['n_cgt_code'];sheet.cell(row=i,column=3).value=t['cgt_name'];sheet.cell(row=i,column=4).value=t['price'];sheet.cell(row=i,column=5).value=t['rtl_price'];i+=1print(i,t['n_cgt_code'],t['cgt_name'],t['price'],t['rtl_price'])wb.save(xlsxName)
print("煙的檔案生成成功！")

[{"co_cont":"13","burst_beads":"0","is_breed":"0","source_type":null,"is_advise":"0","deal_type":"01","gas_nicotine":".9","is_prov_ctrl":"0","is_satisfy":"0","is_co_multi":"1","abnormal_type":null,"cgt_brand_name":"相思鳥","is_imported_name":"省外","is_short_supply":"0","cgt_packet_code":"F6901028195058","mfr_id":"43001","req_qty_old":"0","is_co_lmt":"1","short_code":"14303029","is_short_qty":"0","t_size":null,"is_fav":"2","tactic_type":null,"advise_desc_part":"","is_ramuscule":"0","is_promote":"0","org_code":"11520102","advise_desc":"","cgt_carton_code":"6901028195041","is_imported":"1","n_cgt_code":"F6901028195058","h_size":null,"price_segment":"0","req_qty":"0","net_date":"20200914","category":"","price":"19.08","promote":"","cgt_name":"F相思鳥(軟)","ec_org_cgt_order_rate":null,"sale_t_size":"200","qty_lmt_pure":"99999","is_task":"0","brd_type_name":"新品","ord_qty_old":"0","is_short":"0","pic_url":null,"promote_part":"","brd_type":"1","is_middle":"0","is_show_more":null,"req_qty_init":"0","um_sale_name":"條","mfr_name":"湖南中煙工業有限責任公司","cgt_type_name":"烤煙型","is_cigar":"0","ord_qty":"0","is_thin":"0","rtl_price":"25","qty_lmt":"-1","req_qty_max":"99999","seq":"0","cgt_code":"F6901028195058","is_multi":"0","tar_val":"11","is_base_cgt":"1","cgt_group":"0 "},{"co_cont":"14","burst_beads":"0","is_breed":"0","source_type":null,"is_advise":"0","deal_type":"03","gas_nicotine":"1.1","is_prov_ctrl":"1","is_satisfy":"0","is_co_multi":"1","abnormal_type":null,"cgt_brand_name":"遵義","is_imported_name":"省內","is_short_supply":"1","cgt_packet_code":"6901028036030","mfr_id":"52001","req_qty_old":"0","is_co_lmt":"1","short_code":"108","is_short_qty":"0","t_size":null,"is_fav":"2","tactic_type":"20","advise_desc_part":"","is_ramuscule":"0","is_promote":"0","org_code":"11520102","advise_desc":"","cgt_carton_code":"6901028036047","is_imported":"0","n_cgt_code":"6901028036030","h_size":null,"price_segment":"0","req_qty":"0","net_date":null,"category":"H","price":"23.85","promote":"","cgt_name":"遵義(軟)","ec_org_cgt_order_rate":null,"sale_t_size":"200","qty_lmt_pure":"99999","is_task":"0","brd_type_name":"緊俏","ord_qty_old":"0","is_short":"0","pic_url":null,"promote_part":"","brd_type":"2","is_middle":"0","is_show_more":null,"req_qty_init":"0","um_sale_name":"條","mfr_name":"貴州中煙工業公司","cgt_type_name":"烤煙型","is_cigar":"0","ord_qty":"0","is_thin":"0","rtl_price":"30","qty_lmt":"-1","req_qty_max":"99999","seq":"0","cgt_code":"6901028036030","is_multi":"1","tar_val":"11","is_base_cgt":"1","cgt_group":"0"},{"co_cont":"13","burst_beads":null,"is_breed":"0","source_type":null,"is_advise":"0","deal_type":"03","gas_nicotine":".9","is_prov_ctrl":"1","is_satisfy":"0","is_co_multi":"1","abnormal_type":null,"cgt_brand_name":"雄獅","is_imported_name":"省內","is_short_supply":"0","cgt_packet_code":"6901028207874","mfr_id":"33001","req_qty_old":"0","is_co_lmt":"1","short_code":"610","is_short_qty":"0","t_size":null,"is_fav":"2","tactic_type":"32","advise_desc_part":"","is_ramuscule":"0","is_promote":"0","org_code":"11520102","advise_desc":"","cgt_carton_code":"6901028207881","is_imported":"0","n_cgt_code":"6901028207881","h_size":null,"price_segment":"0","req_qty":"0","net_date":null,"category":"H","price":"28.62","promote":"","cgt_name":"雄獅(硬)","ec_org_cgt_order_rate":null,"sale_t_size":"200","qty_lmt_pure":"99999","is_task":"0","brd_type_name":"順銷","ord_qty_old":"0","is_short":null,"pic_url":null,"promote_part":"","brd_type":"3","is_middle":null,"is_show_more":null,"req_qty_init":"0","um_sale_name":"條","mfr_name":"浙江中煙工業公司","cgt_type_name":"烤煙型","is_cigar":"0","ord_qty":"0","is_thin":"0","rtl_price":"35","qty_lmt":"-1","req_qty_max":"99999","seq":"0","cgt_code":"6901028207881","is_multi":"1","tar_val":"8","is_base_cgt":"1","cgt_group":"0"}]

當然了為了得到煙的檔案資料，下單之后有個導出更方便，直接生成一個煙檔案報表

?