Excel .xlsx (openpyxl)

Extension module providing functions for reading from and writing to Excel (.xlsx) files.

The package openpyxl is required. Instructions for installation can be found at https://bitbucket.org/ericgazoni/openpyxl/wiki/Home or try pip install openpyxl.

petlx.xlsx.fromxlsx(filename, sheet=None, range=None, **kwargs)

Extract a table from a sheet in an Excel (.xlsx) file.

N.B., the sheet name is case sensitive, so watch out for, e.g., ‘Sheet1’.

Changed in version 0.15.

The sheet argument can be omitted, in which case the first sheet in the workbook is used by default.

The range argument can be used to provide a range string specifying a range of cells to extract.

Any other keyword arguments are passed through to openpyxl.load_workbook().

petlx.xlsx.toxlsx(tbl, filename, sheet=None, encoding='utf-8')

Write a table to a new Excel (.xlsx) file.

New in version 0.15.