saving licenses from JSON file(built using pip-licenses) in excel

licenses.py

import json

import xlsxwriter


def main():
    """
    for exporting licenses in json file execute
    pip-licenses --order=license --format=json > licenses.json
    Note! pip-licenses must be installed in the environment
    """
    workbook = xlsxwriter.Workbook('licenses.xlsx')
    worksheet = workbook.add_worksheet()
    bold = workbook.add_format({'bold': True})

    # Text with formatting.
    worksheet.write('A1', 'Name', bold)
    worksheet.write('B1', 'Version', bold)
    worksheet.write('C1', 'License', bold)

    with open('licenses.json') as json_file:
        data = json.load(json_file)
        print(data)
        print(len(data))
        for idx, _license in enumerate(data):
            i = idx + 1
            worksheet.write(i, 0, _license.get('Name'))
            worksheet.write(i, 1, _license.get('Version'))
            worksheet.write(i, 2, _license.get('License'))

    workbook.close()


if __name__ == '__main__':
    main()