Skip to main content

A command utility to read and write data in csv, tsv, xls, xlsx and ods format.

Project description

https://api.travis-ci.org/pyexcel/pyexcel-cli.svg?branch=master https://codecov.io/github/pyexcel/pyexcel-cli/coverage.png https://readthedocs.org/projects/pyexcel-cli/badge/?version=latest

pyexcel-cli brings pyexcel to make it easy to consume/produce information stored in excel files on command line interface. This library can turn the excel data into a list of lists, a list of records(dictionaries), dictionaries of lists. And vice versa. Hence it lets you focus on data in shell programming, instead of file formats.

Hightlighted features:

  1. View data in the excel files without Microsoft Office or Open Office

  2. Transcode data among supported excel file formats

  3. Merge files in various excel file formats into one

  4. Split a multi-sheet excel file into single sheet files

  5. Find difference in data between two excel files

Usage

Here is an example usage:

$ pyexcel view https://github.com/pyexcel/pyexcel-cli/blob/master/tests/fixtures/multiple-sheets.xls
Sheet 1:
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
| 4 | 5 | 6 |
+---+---+---+
| 7 | 8 | 9 |
+---+---+---+
Sheet 2:
+---+---+---+
| X | Y | Z |
+---+---+---+
| 1 | 2 | 3 |
+---+---+---+
| 4 | 5 | 6 |
+---+---+---+
Sheet 3:
+---+---+---+
| O | P | Q |
+---+---+---+
| 3 | 2 | 1 |
+---+---+---+
| 4 | 3 | 2 |
+---+---+---+
A list of file formats supported by external plugins

Plugins

Supported file formats

pyexcel-xls

xls, xlsx(r), xlsm(r)

pyexcel-xlsx

xlsx

pyexcel-ods3

ods (python 2.6, 2.7, 3.3, 3.4)

pyexcel-ods

ods (python 2.6, 2.7)

pyexcel-text

(write only)json, rst, mediawiki, html latex, grid, pipe, orgtbl, plain simple

Known constraints

Fonts, colors and charts are not supported.

Installation

Recently, pyexcel(0.2.2+) and its plugins(0.2.0+) started using newer version of setuptools. Please upgrade your setup tools before install latest pyexcel components:

$ pip install --upgrade setuptools

You can install it via pip:

$ pip install pyexcel-cli

or clone it and install it:

$ git clone http://github.com/pyexcel/pyexcel-cli.git
$ cd pyexcel-cli
$ python setup.py install

License

New BSD License

Change log

0.0.1 - 11.07.2016

Initial release

Project details


Download files

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

Source Distribution

pyexcel-cli-0.0.1.zip (14.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page