python excel 导入导出

最新推荐文章于 2024-09-14 10:43:03 发布

爱吃鱼虾

最新推荐文章于 2024-09-14 10:43:03 发布

阅读量2k

点赞数 2

分类专栏： Django

本文链接：https://blog.csdn.net/xiaofuge027/article/details/80083826

版权

本文介绍了如何使用Python进行Excel文件的数据导入和导出操作。涵盖了使用pandas库读取Excel文件到DataFrame，以及将DataFrame写入Excel的基本步骤，帮助你高效地处理Excel数据。

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

导出

# Excel 导出
class ExportView(View):
    MyModels = AuthSoft
    MyFILES = A_S_FILES_MAP
    NAME = "Test"

    def get(self, request):
        try:
            data = json.loads(request.GET.get("data", None))
        except:
            return HttpResponse("")

        search_data = {}
        if not data:
            data = {}
        for k, v in data.items():
            search_data["{}__icontains".format(k)] = v

        qs = self.MyModels.objects.filter(**search_data).order_by("-id")
        response = self.write_excel(qs)
        filename = "{}{}.xls".format(timezone.now().strftime("%Y-%m-%d"), self.NAME)
        response["Content-Disposition"] = "attachment; filename={}".format(filename)
        return response

    def get_style(self, name, height, bold=False):
        style = xlwt.XFStyle()
        font = xlwt.Font()
        font.name = name
        font.bold = bold
        font.color_index = 4
        font.height = height
        style.font = font
        alignment = xlwt.Alignment()
        alignment.horz = xlwt.Alignment.HORZ_CENTER
        alignment.vert = xlwt.Alignment.VERT_CENTER
        style.alignment = alignment # 数据居中

        return style

    def write_excel(self, qs):
        """将数据写入 Excel中""