3.1. readxl

pylightxl.pylightxl.readxl(fn, ws=None)

Reads an xlsx or xlsm file and returns a pylightxl database

Parameters:
  • fn (str) – Excel file path, also supports Pathlib.Path object, as well as file-like object from with/open
  • or list ws (str) – sheetnames to read into the database, if not specified - all sheets are read entry support single ws name (ex: ws=’sh1’) or multi (ex: ws=[‘sh1’, ‘sh2’])
Returns:

pylightxl.Database class