Excel files (openpyxl)

petlx.xlsx.fromxlsx(filename, sheetname, checksumfun=None)[source]

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’.

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

Previous topic

petlx - Optional Extensions to the petl Package

Next topic

Arrays (numpy)

This Page