Excel .xls (xlrd)

petlx.xls.fromxls(filename, sheet=None, use_view=True)

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

N.B., the sheet name is case sensitive.

The package xlrd is required. Try pip install xlrd.

New in version 0.15.

petlx.xls.toxls(tbl, filename, sheet, encoding='ascii', style_compression=0, styles=None)

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

New in version 0.15.