Django 导出 Excel 代码详解

最新推荐文章于 2024-08-10 07:09:06 发布

chenjinyu_china

最新推荐文章于 2024-08-10 07:09:06 发布

阅读量1w

点赞数 3

分类专栏： Python Django

本文链接：https://blog.csdn.net/chenjinyu_tang/article/details/52156689

版权

本文介绍了如何在Django 1.10环境下利用xlsxwriter库实现Excel文件的导出。通过创建虚拟环境，安装必要依赖，然后详细阐述了当需要导出多个ids时，如何借助session实现这一功能。欢迎探讨更优解决方案。

摘要由CSDN通过智能技术生成

这篇技术贴讲怎样在Django的框架下导出Excel，最开始打算用ajax post data 过去，但是发现不行，所以改用了get的方式。如果只有一个id(pk)那用get的方式很简单就可以访问对应的view section，但是如果是多个ids，我用的是session，大家还有其他好的例子吗？希望一起讨论。

Python3.5 Django 1.10, sqlite3, windows 10

1. virtualenv export_excel <--- create a virtualenv for django

2. cd export_excel <--- go into the export_excel folder

3. Script\active <--- activate env environment.

once activate the environment, in the windows would be liked as above.

4. pip install django.

5. pip install django-bootstrap3. <-- bootstrap3 for django.

6. pip install xlsxwriter. <-- this uses for excel export.(用xlsxwriter 这个python 库)

1. urls.py

"""export_excel URL Configuration


The `urlpatterns` list routes URLs to views. For more information please see:
    https://docs.djangoproject.com/en/1.10/topics/http/urls/
Examples:
Function views
    1. Add an import:  from my_app import views
    2. Add a URL to urlpatterns:  url(r'^$', views.home, name='home')
Class-based views
    1. Add an import:  from other_app.views import Home
    2. Add a URL to urlpatterns:  url(r'^$', Home.as_view(), name='home')
Including another URLconf
    1. Import the include() function: from django.conf.urls import url, include
    2. Add a URL to urlpatterns:  url(r'^blog/', include('blog.urls'))
"""
from django.conf.urls import url
from django.contrib import admin
from django.views.generic import ListView


from .models import ExcelDemoData
from . import views


urlpatterns = [
    url(r'^admin/', admin.site.urls),
    url(r'^$',  ListView.as_view(queryset = ExcelDemoData.objects.all().defer('id', 'part_number').order_by('id')[:100], template_name="part_num_list.html"), name = 'home'),
    url(r'^demo/exportall/$',  views.export_all_to_excel, name = 'export_all_to_excel'),
]

2. views.py

from django.http import JsonResponse, Http404
from django.shortcuts import render, get_object_or_404, render_to_response  
from django.http import HttpResponseRedirect
from django.contrib import messages
from django.core.urlresolvers import reverse
from django.http import HttpResponse

from .models import ExcelDemoData
from .forms import ExcelDemoForm
from .excel_utils import WriteToExcel

from . import attrs_override as attr

        
def export_sig_to_excel(request, pk):

    if request.method == 'GET':
        demo_list = []
        try:
            demo_row = ExcelDemoData.objects.get(pk = pk)
        except ExcelDemoData.DoesNotExist:
            messages.add_message(request, messages.ERROR, 'the Part Number: [%s] does not exist in database.'  % str(pk))
        else:    
            demo_list.append(demo_row)
              
        response = HttpResponse(content_type='application/ms-excel')
        response['Content-Disposition'] = 'attachment; filename=ExcelDemoD