pyexcel - Let you focus on data, instead of file formats¶
pyexcel is a wrapper library to read, manipulate and write data in different excel formats: csv, ods, xls, xlsx and xlsm. It does not support styling, charts.
It was created due to the lack of uniform programming interface to access data in different formats. A developer needs to use different methods of different libraries to read the same data in different excel formats, hence the resulting code is cluttered and unmaintainable.
All great work have done by odf, xlrd and other individual developers. This library unites only the data access code.
For ods, xls, xlsx and xlsm, only first sheet(index at 0) is under consideration. The support for multiple spread sheets are considered in next version.
You can install it via pip:
$ pip install pyexcel
Getting the source¶
Source code is hosted in github. You can get it using git client:
$ git clone http://github.com/chfw/pyexcel.git
- pyexcel package