python-小知识点总结
2021/8/11 20:07:10
本文主要是介绍python-小知识点总结,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
【导出】功能总结
import openpyxl from utils.excel_utils import ExcelUtils from openpyxl.writer.excel import save_virtual_workbook from django.http import JsonResponse, HttpResponse def cvt_pool_history_export(ls_obj): wb = openpyxl.Workbook() ws = wb.active ws.append(["调整日期", "简称"]) for dic in ls_obj: ws.append(( dic.get("created_time"), dic.get("simple_name"), )) ExcelUtils.format_excel(ws) ExcelUtils.simple_fmt_wh(ws) return save_virtual_workbook(wb) def list(self, request, *args, **kwargs): queryset = self.filter_queryset(self.get_queryset()) serializer = self.get_serializer(queryset, many=True) buffer = cvt_pool_history_export(serializer.data) response = HttpResponse( buffer, content_type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", ) response["Content-Disposition"] = "attachment; filename=XX导出.xlsx" return response
这篇关于python-小知识点总结的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-08有遇到过吗?同样的规则 Excel 中 比Python 结果大
- 2024-03-30开始python成长之路
- 2024-03-29python optparse
- 2024-03-29python map 函数
- 2024-03-20invalid format specifier python
- 2024-03-18pool.map python
- 2024-03-18threads in python
- 2024-03-14python Ai 应用开发基础训练,字符串,字典,文件
- 2024-03-13id3 algorithm python
- 2024-03-13sum array elements python