pyexcel - Let you focus on data, instead of file formats

Author:C.W. Source code:http://github.com/chfw/pyexcel Issues:http://github.com/chfw/pyexcel/issues License:GPL v3 Version:0.0.1

Introduction

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.

Constraints

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.

Installation

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

Usage examples

Tutorial

• Work with data series
  • Read an excel file
  • Play with data
  • Filter out some data
  • Save the data
• Work with pure data
  • Read an excel file
  • Pay with data

Cook book

• Simple usage
  • Update one column of a data file
  • Merge two files into one
  • Select candidate columns of two files and form a new one

API documentation

• pyexcel package
  • Core packages
    • pyexcel.readers module
      • pyexcel.readers
    • pyexcel.writers module
      • pyexcel.writers
    • pyexcel.iterators module
      • pyexcel.iterators
    • pyexcel.filters module
  • Utility packages
    • pyexcel.cookbook package
      • pyexcel.cookbook
    • pyexcel.cookbook package
      • pyexcel.utils
    • pyexcel.ext package
      • pyexcel.ext.odsreader

Indices and tables

• Index
• Module Index
• Search Page