[FIXED] generate Excel files from DB response. Flask REST API

Issue

I'm trying to generate excel/CSV files as a response generated at runtime. I tried using flask-excel but not getting the expected results. For example: if the data in DB is,

| name | age | sex   |
| ---- | --- | ----- |
| Ram  | 25  | male  |
| Sita | 24  | female|

the output excel should look similar to this.

Solution

Flask Excel does the job, but the installation steps are slightly different from what's mentioned on the documentation

1. import flask_excel
2. init
3. Use flask_excel.make_response_from_array or other relevant functions.

This should work

Answered By - Ganesh Sharma