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.
0 kommentar(er)
