Skip to main content

Simple commandline utility to convert excel filesto searchable and sortable HTML table.

Project description

Excel2Table

https://api.travis-ci.org/pyexcel/excel2table.svg?branch=master https://codecov.io/gh/pyexcel/excel2table/branch/master/graph/badge.svg

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

Change log

2.2.1 - 21.02.2017

Added

  1. Visualize stock data with candlestick, bar and line csvtotable PR 24

Updated

  1. Update baseline of csvtotable to 2.1.1

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
excel2table-2.2.1-py2.py3-none-any.whl (390.3 kB) Copy SHA256 hash SHA256 Wheel 2.7
excel2table-2.2.1.tar.gz (298.8 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page