Metadata-Version: 2.0
Name: excel2table
Version: 2.2.1
Summary: Simple commandline utility to convert excel filesto searchable and sortable HTML table.
Home-page: https://github.com/pyexcel/excel2table
Author: C. W.
Author-email: wangc_2011@hotmail.com
License: MIT
Download-URL: https://github.com/pyexcel/excel2table/archive/2.2.1.tar.gz
Description-Content-Type: UNKNOWN
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Programming Language :: Python
Classifier: Natural Language :: English
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Topic :: Software Development :: Libraries
Requires-Dist: click (>=6.7)
Requires-Dist: jinja2 (>=2.9.6)
Requires-Dist: pyexcel (>=0.5.0)
Requires-Dist: six (>=1.10.0)
Requires-Dist: pyexcel-xls (>=0.4.0)
Requires-Dist: pyexcel-odsr (>=0.4.0)

Excel2Table
============

.. image:: https://api.travis-ci.org/pyexcel/excel2table.svg?branch=master
   :target: http://travis-ci.org/pyexcel/excel2table

.. image:: https://codecov.io/gh/pyexcel/excel2table/branch/master/graph/badge.svg
  :target: https://codecov.io/gh/pyexcel/excel2table


Simple command-line utility to convert csv, xls, xlsx, ods files to searchable and
sortable HTML table. Supports large datasets and horizontal scrolling for large number of columns.

It is a variant of `csvtotable <https://github.com/vividvilla/csvtotable>`_.

Demo
----

`Here is a demo`_ of `sample ods`_ file converted to HTML table with charts.

.. image:: https://user-images.githubusercontent.com/4280312/30404140-006c035e-98dd-11e7-9cfd-1fcf3e405e2f.gif

Installation
------------

::

    pip install --upgrade excel2table


Get started
-----------

::

    excel2table --help

Convert ``data.ods`` file to ``data.html`` file

::

    excel2table data.ods data.html

Open output file in a web browser instead of writing to a file

::

    excel2table data.ods --serve

Options
-------

::

    -c,  --caption          Table caption
    -d,  --delimiter        CSV delimiter. Defaults to ','
	-e,  --encoding         CSV encoding. Defaults to 'utf-8'.
    -q,  --quotechar        Quote chracter. Defaults to '"'
    -dl, --display-length   Number of rows to show by default. Defaults to -1 (show all rows)
    -o,  --overwrite        Overwrite the output file if exists. Defaults to false.
    -s,  --serve            Open html output in a web browser.
    -h,  --height           Table height in px or in %. Default is 75% of the page.
    -p,  --pagination       Enable/disable pagination. Enabled by default.
    -vs, --virtual-scroll   Number of rows after which virtual scroll is enabled. Default is set to 1000 rows.
                            Set it to -1 to disable and 0 to always enable.
    -nh, --no-header        Show default headers instead of picking first row as header. Disabled by default.
    -e,  --export           Enable filtered rows export options.
    -eo, --export-options   Enable specific export options. By default shows all.
                            For multiple options use -eo flag multiple times. For ex. -eo json -eo csv

Credits
-------
`Datatables`_

.. _Here is a demo: https://github.com/pyexcel/excel2table/master/sample/goog.html
.. _sample ods: https://github.com/pyexcel/excel2table/blob/master/sample/goog.ods
.. _Datatables: https://datatables.net

Change log
=============



2.2.1 - 21.02.2017
------------------------

Added
*******

#. Visualize stock data with candlestick, bar and line
   csvtotable `PR 24 <https://github.com/vividvilla/csvtotable/pull/24>`_

Updated
************

#. Update baseline of csvtotable to 2.1.1



