petlx is a collection of extensions to petl, a tentative Python module for extracting, transforming and loading tables of data.
For an overview of all functions in the package, see the Index.
This module is available from the Python Package Index. On Linux distributions you should be able to do easy_install petlx or pip install petlx. On Windows or Mac you can download manually, extract and run python setup.py install.
Extract a table from a sheet in an Excel (.xlsx) file.
Note that the package openpyxl is required. Instructions for installation can be found at https://bitbucket.org/ericgazoni/openpyxl/wiki/Home.
N.B., the sheet name is case sensitive, so watch out for, e.g., ‘Sheet1’.