Worksheet.write(row, 5, employee.get('employeeFirstName')) Worksheet.write(row, 4, employee.get('employeeLastName')) Worksheet.write(row, 3, employee.get('employeeId')) Worksheet.write(row, 2, obj.get('companyStatus')) Worksheet.write(row, 1, obj.get('companyName')) Worksheet.write(row, 0, obj.get('companyId')) rge_range(2, 20, 4, 20, 'totalApprovedAmount', merge_format) # U rge_range(2, 17, 4, 17, 'reportCreationDate', merge_format) # R

rge_range(2, 13, 4, 13, 'approvedAmount', merge_format) # N

Worksheet.write(4, 9, 'journalPayer') # J Worksheet.write(4, 8, 'journalPayee') # I Worksheet.write(4, 7, 'journalAccountCode') # H rge_range(3, 6, 4, 6, 'allocationId', merge_format) # G rge_range(1, 6, 1, 15, 'expenseEntry', merge_format) # G-P rge_range(2, 5, 4, 5, 'employeeFirstName', merge_format) # F rge_range(2, 4, 4, 4, 'employeeLastName', merge_format) # E rge_range(2, 3, 4, 3, 'employeeId', merge_format) # D rge_range(0, 2, 4, 2, 'companyStatus', merge_format) # C rge_range(0, 1, 4, 1, 'companyName', merge_format) # B rge_range(0, 0, 4, 0, 'companyId', merge_format) # A # create a sheet for our work, defaults to Sheet1. Workbook = xlsxwriter.Workbook(xlsx_file) After that, I entered values using according to your JSON. First I made the template with some cell format stuff. Here is the code what you are looking for. Would anyone please help me in this case? Thank you so much. I tried with json_excel_converter from json_excel_converter import Converterįrom json_excel_converter.xlsx import WriterĬonv.convert(data, Writer(file='test.xlsx')) I'm using Python 3.8 with xlsxwriter library.Īnd my current tried with pandas import pandas as pdĭf = pd.json_normalize(data, max_level=5) I have a JSON that need to convert to Excel.

Convert json to excel