Metadata-Version: 2.1
Name: django-excel-storage
Version: 2.0.2
Summary: Django Excel Storage
Home-page: https://github.com/django-xxx/django-excel-storage
Author: Hackathon
Author-email: kimi.huang@brightcells.com
License: UNKNOWN
Keywords: django-excel-storage
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Environment :: Web Environment
Classifier: Framework :: Django
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Topic :: Office/Business :: Financial :: Spreadsheet
Requires-Dist: django-excel-base (>=1.0.3)
Requires-Dist: django-six (>=1.0.4)

====================
django-excel-storage
====================

Installation
============

::

    pip install django-excel-storage


Usage
=====

::

    from django_excel_storage import ExcelStorage

    def excelfunc():
        objs = SomeModel.objects.all()
        fpath = ExcelStorage(data).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()


Params
======

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


CSV
===

+-----------------+----------------+----------------+----------------+-------------+
|                 | Win Excel 2013 | Mac Excel 2011 | Mac Excel 2016 | Mac Numbers |
+=================+================+================+================+=============+
| UTF8            | Messy          | Messy          | Messy          | Normal      |
+-----------------+----------------+----------------+----------------+-------------+
| GB18030         | Normal         | Normal         | Normal         | Messy       |
+-----------------+----------------+----------------+----------------+-------------+
| UTF8 + BOM_UTF8 | Normal         | Messy          | Normal         | Normal      |
+-----------------+----------------+----------------+----------------+-------------+
| UTF16LE + BOM   |                |                |                |             |
+-----------------+----------------+----------------+----------------+-------------+


