Convert EXCEL (as shown below ) into API JSON Response.
Install Package
pip install excel2jsonapi
Excel Format
>>> import excel2jsonapi
>>> excel2jsonapi.create('~/Desktop/excel2jsonapi/example/sample.xlsx')
Response:
[
{
"Name":"Rat",
"Phone Number":"99999999",
"Email":"rat@example.com"
},
{
"Name":"Cat",
"Phone Number":"88888888",
"Email":"cat@example.com"
},
{
"Name":"Dog",
"Phone Number":"77777777",
"Email":"dog@example.com"
}
]