Metadata-Version: 2.1
Name: excel-storage
Version: 1.0.0
Summary: Excel Storage
Home-page: https://github.com/Brightcells/excel-storage
Author: Hackathon
Author-email: kimi.huang@brightcells.com
License: UNKNOWN
Keywords: Excel Storage
Platform: UNKNOWN
Classifier: License :: OSI Approved :: BSD License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.5
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.2
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Requires-Dist: excel-base

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

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

::

    pip install excel-storage


Usage
=====

::

    from 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 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 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
===

+-----------------+----------------+----------------+----------------+-------------+
|                 | 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   |                |                |                |             |
+-----------------+----------------+----------------+----------------+-------------+


