All notes
Excel

Django-excel

readTheDocs: django-excel.

It uses pyexcel and its plugins.

Installation


pip install django-excel

Setup

You will need to update your settings.py:


FILE_UPLOAD_HANDLERS = ("django_excel.ExcelMemoryFileUploadHandler",
                        "django_excel.TemporaryExcelFileUploadHandler")

pyexcel

python.org: pyexcel.


import pyexcel as pe
an_array = [[1,2]]
sheet = pe.Sheet(an_array)

sheet.json
# '{"pyexcel sheet": [[1, 2]]}'
sheet.tsv
# '1\t2\r\n'
sheet.csv
# '1,2\r\n'