Arsip05Python

python : json to xlsx
import xlsxwriter
import json
import os
import datetime
dnama = 'data.bis'
tim = datetime.datetime.now()
tim = tim.strftime("%Y%m%d")
xlsna = 'BARCODE_'+tim+'.xlsx'
workbook = xlsxwriter.Workbook(xlsna)
worksheet = workbook.add_worksheet()
row = 0
col = 0
print ('\n##### EXPORT DATA BARCODE #####\n')

worksheet.write(0, 0, '##### Applikasi Data Barcode - Citra Raja Ampat Sorong ######')
worksheet.write(1, 0, ' B A R C O D E ')
worksheet.write(1, 1, 'NAMA/KETERANGAN')
row += 2
with open(dnama) as json_file:  
   data = json.load(json_file)
   for f in data:
        if data[f] != '0':
           worksheet.write(row, col,     f)
    	   worksheet.write(row, col + 1, data[f])
    	   row += 1
           print(f+' : '+data[f])
print ('\n##### [email protected] #####\n')
workbook.close()

-------- format json ------
{"1234": "[email protected]"}