django 导出Excel 参考示例

原创

已于 2024-03-26 17:15:35 修改 · 242 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#django

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

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", "Curr