django-excel-storage

Django Excel Storage

Installation

pip install django-excel-storage

Usage

from django_excel_storage import ExcelStorage

def excelfunc():
    objs = SomeModel.objects.all()
    fpath = ExcelStorage(objs).save()

or

from django_excel_storage import ExcelStorage

def excelfunc():
    data = [
        {
            'Column 1': 1,
            'Column 2': 2,
        },
        {
            'Column 1': 3,
            'Column 2': 4,
        }
    ]
    fpath = ExcelStorage(data, 'my_data', font='name SimSum').save()

or

from django_excel_storage import ExcelStorage

def excelfunc():
    data = [
        ['Column 1', 'Column 2'],
        [1, 2],
        [3, 4]
    ]
    fpath = ExcelStorage(data, 'my_data', font='name SimSum').save()

or

from django_excel_storage import ExcelStorage

def excelfunc():
    data = [
        ['Column 1', 'Column 2'],
        [1, [2, 3]],
        [3, 4]
    ]
    fpath = ExcelStorage(data, 'my_data', font='name SimSum', row_merge=True).save()

Params

• font='name SimSum'
  • Set Font as SimSum(宋体)
• force_csv=True
  • CSV Format? True for Yes, False for No, Default is False

CSV

datas = [
    [u'中文', ]
]