django 导出Excel 参考示例

克里斯蒂亚诺更新

已于 2024-03-26 17:15:35 修改

阅读量113

点赞数 2

分类专栏： django 文章标签： django

于 2024-03-26 17:01:00 首次发布

本文链接：https://blog.csdn.net/weixin_36152801/article/details/137051524

版权

django 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

Html:

<form method="post" action="/company/project/exportexcel" style="  display: inline-block;">
                    {% csrf_token %}
                    <input type="hidden" name="export_option" value="some_value">
                    <button class="btn btn-sm btn-warning" type="submit" style="margin-bottom: 10px"><i
                            class="mdi mdi-export"></i>导出
                    </button>
                </form>

urls.py

path('exportexcel', views.exportexcel.as_view(), name='company-project-exportexcel'),

views.py:



class exportexcel(LoginRequiredMixin, BaseView):
    def post(self, request):

        projects = ProjectModel.objects.using('company').all()

        # 创建一个新的Excel工作簿
        wb = Workbook()
        ws = wb.active
        ws.title = "ProjectList"

        # 添加表头
        ws.append(["ID", "Code", "Project Name", "Company Name", "Current Stage", "Contracted Time",
                   "Completion Time", "Status Plan", "Assigned Personnel", "Project Manager"])

        ws.append(["ID", "代码", "项目名称", "公司名称", "当前阶段", "合同时间",
                   "完成时间", "状态计划", "解决人员", "项目经理"])

        # 添加数据
        for project in projects:
            # assigned_personnel = ','.join([member.name for member in project.assigned_personnel.all()])
            assigned_personnel = project.assigned_personnel
            ws.append([
                project.id, project.code, project.project_name, project.company_name, project.current_stage,
                project.contracted_time.strftime('%Y-%m-%d %H:%M:%S') if project.contracted_time else None,
                project.completion_time.strftime('%Y-%m-%d %H:%M:%S') if project.completion_time else None,
                project.status_plan, assigned_personnel, project.project_manager
            ])

        # 创建响应对象
        response = HttpResponse(content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
        response['Content-Disposition'] = 'attachment; filename="project_list.xlsx"'

        # 将Excel内容写入响应对象
        wb.save(response)
        return response

如果要一边分页一边导出Excel表，这样写：

Html:

 <form method="post" action="/company/project/exportexcel" style="  display: inline-block;">
                    {% csrf_token %}
                    <input type="hidden" name="page" value="{{ request.GET.page }}">
                    <button class="btn btn-sm btn-warning" type="submit" style="margin-bottom: 10px"><i
                            class="mdi mdi-export"></i>导出整表
                    </button>
                </form>

views.py:


class exportexcel(LoginRequiredMixin, BaseView):
    def post(self, request):
        # 获取当前页数
        page_number = request.POST.get('page')
        if not page_number:
            page_number=1
        # 每页显示的数量
        page_size = 10

        # 查询项目数据
        projects = ProjectModel.objects.using('company').all()

        # 创建分页器
        paginator = Paginator(projects, page_size)

        try:
            # 获取指定页数的数据
            page_obj = paginator.page(page_number)
            projects = page_obj.object_list

            # 创建一个新的Excel工作簿
            wb = Workbook()
            ws = wb.active
            ws.title = "ProjectList"

            # 添加表头
            ws.append(["ID", "代码", "项目名称", "公司名称", "当前阶段", "合同时间",
                       "完成时间", "状态计划", "解决人员", "项目经理"])

            # 添加数据
            for project in projects:
                # assigned_personnel = ','.join([member.name for member in project.assigned_personnel.all()])
                assigned_personnel = project.assigned_personnel
                ws.append([
                    project.id, project.code, project.project_name, project.company_name, project.current_stage,
                    project.contracted_time.strftime('%Y-%m-%d %H:%M:%S') if project.contracted_time else None,
                    project.completion_time.strftime('%Y-%m-%d %H:%M:%S') if project.completion_time else None,
                    project.status_plan, assigned_personnel, project.project_manager
                ])

            # 创建响应对象
            response = HttpResponse(content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
            response['Content-Disposition'] = 'attachment; filename="project_list.xlsx"'

            # 将Excel内容写入响应对象
            wb.save(response)
            return response

        except EmptyPage:
            return HttpResponse("Invalid page number")