python数据导出excel,如何以excel格式导出python中的数据？

views.py

def export_to_excel(request):

lists = MyModel.objects.all()

# your excel html format

template_name = "sample_excel_format.html"

response = render_to_response(template_name, {'lists': lists})

# this is the output file

filename = "model.csv"

response['Content-Disposition'] = 'attachment; filename='+filename

response['Content-Type'] = 'application/vnd.ms-excel; charset=utf-16'

return response

urls.py

from django.conf.urls.defaults import *

urlpatterns = patterns('app_name.views',

url(r'^export/$', 'export_to_excel', name='export_to_excel'),

)

Last, in your page create a button or link that will point in exporting.

page.html

Export

Nothing getting file option for download and not giving any error but i can see all result in log its working fine.

解决方案

In addition to the options shown in the other answers you can also use XlsxWriter to create Excel files.