Django Excel存储
django-excel-storage的Python项目详细描述
安装
pip install django-excel-storage
用法
from excel_storage import ExcelStorage def excelfunc(): objs = SomeModel.objects.all() fpath = ExcelStorage(data).save()
或:
from excel_storage import ExcelStorage def excelfunc(): data = [ ['Column 1', 'Column 2'], [1, 2], [3, 4] ] fpath = ExcelStorage(data, 'my_data', font='name SimSum')
参数
- 设置字体为simsum(宋20307;)
- 强制csv=真
- CSV格式?是为真,否为假,默认为假
csv
Win Excel 2013 | Mac Excel 2011 | Mac Excel 2016 | Mac Numbers | |
---|---|---|---|---|
UTF8 | Messy | Messy | Normal | |
GB18030 | Normal | Normal | Messy | |
UTF8 + BOM_UTF8 | Normal | Messy | Normal |