How to convert a Excel file into Json using Python Openpyxl ?

code.py

import openpyxl # pip install openpyxl
from var_dump import var_dump   # pip install var_dump , this method has the same behaviour like the PHP ones.
import json 
import datetime

now = datetime.datetime.now()

path = "./atarada.xlsx" # path to your xlsx file
wb_obj = openpyxl.load_workbook( path )
sheet_obj = wb_obj.active

headers = {} # store xlsx file headers 
content = [] # store xlsx file rows

for idx, rows in enumerate(sheet_obj):
    ctt = {}
    row_in_sheets = len( rows )
    if idx == 0 :
        for idt, vl in enumerate(rows):
            headers[idt] = vl.value
    else:
        for idx,vl in enumerate(rows):
            vlcv = vl.value 
            if isinstance(vl.value, datetime.datetime):
                vlcv = 0
            ctt[headers[idx]] = vlcv
        content.append(ctt)

with open('product.json', 'w') as f:
    json.dump(content, f)  # store the result into this json file