Django数据导出excel文件

最新推荐文章于 2024-01-24 17:28:50 发布

叼奶嘴的超人

最新推荐文章于 2024-01-24 17:28:50 发布

阅读量574

点赞数

分类专栏： Django2.2.7 Python3.8

本文链接：https://blog.youkuaiyun.com/vlking/article/details/105373314

版权

Python3.8 同时被 2 个专栏收录

21 篇文章

订阅专栏

Django2.2.7

17 篇文章

订阅专栏

本文介绍了一种将图书信息从数据库导出到Excel的方法，包括设置语言编码为utf-8以支持中文，创建Excel表格并定义列标题，然后遍历数据库中的图书信息并将其写入Excel表格中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

需要安装pip install xlwt
def export_book(request):
    bookinfo = Books.objects.all()
    if bookinfo:
        # 设置语言，建议是utf-8因为需要中文支持
        language = Workbook(encoding='utf-8')
        # 创建excel表
        w = language.add_sheet(u"sheet1")
        w.write(0, 0, "ID编号")
        w.write(0, 1, u"图书种类")
        w.write(0, 2, u"图书名称")
        w.write(0, 3, u"入库几册")
        w.write(0, 4, u"图书国籍")
        w.write(0, 5, u"是否入库")
        w.write(0, 6, u"图书价格")
        w.write(0, 7, u"添加时间")
        w.write(0, 8, u"上传图片名称")
        # 写入数据
        excel_row = 1
        for obj in bookinfo:
            data_id = obj.booksid
            data_species = obj.booksspecies
            data_name = obj.booksname
            data_number = obj.booksnumber
            dada_country = obj.bookscountry
            dada_storage = obj.booksstorage
            dada_money = obj.booksmoney
            dada_times = obj.bookstimes
            dada_img_name = obj.booksimg_name
            w.write(excel_row, 0, data_id)
            w.write(excel_row, 1, data_species)
            w.write(excel_row, 2, data_name)
            w.write(excel_row, 3, data_number)
            w.write(excel_row, 4, dada_country)
            w.write(excel_row, 5, dada_storage)
            w.write(excel_row, 6, dada_money)
            w.write(excel_row, 7, dada_times)
            w.write(excel_row, 8, dada_img_name)
            excel_row += 1
        # 保存文件
        exist_file = os.path.exists("export_info.xls")
        if exist_file:
            os.remove(r"export_info.xls")
        language.save("export_info.xls")
        # 这里使用io流.
        ioa = BytesIO()
        language.save(ioa)
        ioa.seek(0)
        response = HttpResponse(ioa.getvalue(), content_type='application/vnd.ms-excel')
        response['Content-Disposition'] = 'attachment; filename=export_info.xls'
        response.write(ioa.getvalue())
        return response