pyexcel package

Utility packages

pyexcel.cookbook package

pyexcel.cookbook

Cookbook for pyexcel

copyright:
  1. 2014 by C. W.
license:

GPL v3
pyexcel.cookbook.merge_files(file_array, outfilename='pyexcel_merged.csv')[source]

merge many files

pyexcel.cookbook.merge_readers(reader_array, outfilename='pyexcel_merged.csv')[source]

merge many readers

With FilterableReader and SeriesReader, you can do custom filtering

pyexcel.cookbook.merge_two_files(file1, file2, outfilename='pyexcel_merged.csv')[source]

merge two files

pyexcel.cookbook.merge_two_readers(reader1, reader2, outfilename='pyexcel_merged.csv')[source]

merge two readers

pyexcel.cookbook.update_columns(infilename, column_dicts, outfilename=None)[source]

Update one or more columns of a data file with series

pyexcel.cookbook package

pyexcel.utils

Utility functions for pyexcel

copyright:
  1. 2014 by C. W.
license:

GPL v3
pyexcel.utils.to_array(iterator)[source]

convert a reader iterator to an array

pyexcel.utils.to_dict(iterator)[source]

convert a reader iterator to a dictionary

pyexcel.utils.to_one_dimensional_array(iterator)[source]

convert a reader to one dimensional array

pyexcel.ext package

pyexcel.ext.odsreader

Uniform interface for writing different excel file formats

copyright:
  1. 2011 by Marco Conti
license:

Apache License 2.0
class pyexcel.ext.odsreader.ODSReader(file)[source]
getSheet(name)[source]
readSheet(sheet)[source]