Skip to content

Simple command-line utility to convert Excel files to searchable and sortable HTML table.

License

Notifications You must be signed in to change notification settings

pyexcel/excel2table

 
 

Repository files navigation

Excel2Table

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

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.

Demo

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

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

About

Simple command-line utility to convert Excel files to searchable and sortable HTML table.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 96.6%
  • JavaScript 2.3%
  • Other 1.1%