django excel xlwt

by

neat package! i didn’t know about this

According to the doc, the save(filename_or_stream) method takes either a filename to save on, or a file-like stream to write on.

And a Django response object happens to be a file-like stream! so just do xls.save(response). Look the Django docs about generating PDFs with ReportLab to see a similar situation.

edit: (adapted from ShawnMilo’s comment):

def xls_to_response(xls, fname):
    response = HttpResponse(mimetype="application/ms-excel")
    response['Content-Disposition'] = 'attachment; filename=%s' % fname
    xls.save(response)
    return response

then, from your view function, just create the xls object and finish with 

return xls_to_response(xls,'foo.xls')

More Related Contents:

  1. Insert row into Excel spreadsheet using openpyxl in Python
  2. Edit existing excel workbooks and sheets with xlrd and xlwt
  3. XlsxWriter object save as http response to create download in Django
  4. Append existing excel sheet with new dataframe using python pandas
  5. How do I filter ForeignKey choices in a Django ModelForm?
  6. Cron and virtualenv
  7. How to call python script on excel vba?
  8. Django – No such table: main.auth_user__old
  9. Expire a view-cache in Django?
  10. How do I read a date in Excel format in Python?
  11. No module named ‘polls.apps.PollsConfigdjango’; Django project tutorial 2
  12. How to call function that takes an argument in a Django template?
  13. Can you give a Django app a verbose name for use throughout the admin?
  14. Python Django Global Variables
  15. Django : Table doesn’t exist
  16. How to write/update data into cells of existing XLSX workbook using xlsxwriter in python
  17. django – convert a list back to a queryset [duplicate]
  18. How do I separate my models out in django?
  19. django best approach for creating multiple type users
  20. Using request.user with Django ModelForm
  21. How to execute arithmetic operations between Model fields in django
  22. gunicorn autoreload on source change
  23. What is the best approach to change primary keys in an existing Django app?
  24. Order of Serializer Validation in Django REST Framework
  25. Difference between AbstractUser and AbstractBaseUser in Django?
  26. How to expire Django session in 5minutes?
  27. Django Admin – Disable the ‘Add’ action for a specific model
  28. Django equivalent of PHP’s form value array/associative array
  29. Single Table Inheritance in Django
  30. How to implement a “back” link on Django Templates?

Leave a Comment