pyexcel-io 0.2.3

A python library to read and write structured data in csv, zipped csv format and to/from databases

pyexcel-io provides one application programming interface(API) to read and write the data in excel format, import the data into and export the data from database. It provides support for csv(z) format, django database and sqlalchemy supported databases. Its supported file formats are extended to cover “xls”, “xlsx”, “ods” by the following extensions:

A list of file formats supported by external plugins

Package name	Supported file formats	Dependencies	Python versions
pyexcel-io	csv, csvz [1], tsv, tsvz [2]		2.6, 2.7, 3.3, 3.4, 3.5, pypy, pypy3
pyexcel-xls	xls, xlsx(read only), xlsm(read only)	xlrd, xlwt	same as above
pyexcel-xlsx	xlsx	openpyxl	same as above
pyexcel-xlsxw	xlsx(write only)	xlsxwriter	same as above
pyexcel-ods3	ods	ezodf, lxml	2.6, 2.7, 3.3, 3.4 3.5
pyexcel-ods	ods	odfpy	same as above

Footnotes

[1]

zipped csv file

[2]

zipped tsv file

If you need to manipulate the data, you might do it yourself or use its brother library pyexcel .

If you would like to extend it, you may use it to write your own extension to handle a specific file format.

Known constraints

Fonts, colors and charts are not supported.

Installation

You can install it via pip:

$ pip install pyexcel-io

or clone it and install it:

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

License

New BSD License

Change log

0.24 - unreleased

Updated

1. #19, use cString by default

0.23 - unreleased

Added

1. #21, choose subset from data base tables for export

2. #22, custom renderer if given row_renderer as parameter.

0.22 - 31.08.2016

Added

1. support pagination. two pairs: start_row, row_limit and start_column, column_limit help you deal with large files.

2. skip_empty_rows=True was introduced. To include empty rows, put it to False.

Updated

1. #20, pyexcel-io attempts to parse cell contents of ‘infinity’ as a float/int, crashes

0.2.1 - 11.07.2016

Added

1. csv format: handle utf-16 encoded csv files. Potentially being able to decode other formats if correct “encoding” is provided

2. csv format: write utf-16 encoded files. Potentially other encoding is also supported

3. support stdin as input stream and stdout as output stream

Updated

1. Attention, user of pyexcel-io! No longer io stream validation is performed in python 3. The guideline is: io.StringIO for csv, tsv only, otherwise BytesIO for xlsx, xls, ods. You can use RWManager.get_io to produce a correct stream type for you.

2. #15, support foreign django/sql foreign key

0.2.0 - 01.06.2016

Added

1. autoload of pyexcel-io plugins

2. auto detect datetime, float and int. Detection can be switched off by auto_detect_datetime, auto_detect_float, auto_detect_int

0.1.0 - 17.01.2016

Added

# yield key word to return generator as content