Excel .xls (xlrd)

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

The packages xlrd, xlwt and xlutils are required. Try pip install xlrd xlwt xlutils.

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

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

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

New in version 0.15.

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

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

New in version 0.15.