xlsx_streaming library lets you stream data from your database to an xlsx document. The xlsx document can hence be streamed over HTTP without the need to store it in memory on the server. Database queries are made by batch, making it safe to export even very large tables.
Bug reports, patches and suggestions welcome! Just open an issue or send a pull request.
After having installed the development requirements, just run:
python -m unittest discover