A command utility to read and write data in csv, tsv, xls, xlsx and ods format.
Project description
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:
View data in the excel files without Microsoft Office or Open Office
Transcode data among supported excel file formats
Merge files in various excel file formats into one
Split a multi-sheet excel file into single sheet files
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 |
+---+---+---+
Plugins |
Supported file formats |
---|---|
xls, xlsx(r), xlsm(r) |
|
xlsx |
|
ods (python 2.6, 2.7, 3.3, 3.4) |
|
ods (python 2.6, 2.7) |
|
(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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.