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.
The full documentation can be found on readthedocs.
Bug reports, patches and suggestions welcome! Just open an issue or send a pull request.
As simple as:
python setup.py test