installation :
pip install git+{reponame}
example read :
from xl import XL
file_path = "./1.xlsx"
sheet_name = "Sheet"
with XL(file_path) as excel_to_dict:
data = excel_to_dict.sheet_to_dict(sheet_name)
print(data)
example write :
from xl import XL
file_path = "./1.xlsx"
data = [
{"Name":"Alice", "Age":30},
{"Name":"Bob", "Age":25},
{"Name":"Charlie", "Age":35},
]
XL(file_path).json_to_sheet(data)