3.1. readxl

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

Reads an xlsx or xlsm file and returns a pylightxl database

Parameters:
  • fn (Union[str, pathlib.Path]) – Excel file path, also supports Pathlib.Path object, as well as file-like object from with/open
  • ws (Union[str,List[str]], optional) – 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’]), defaults to None
Returns:

pylightxl Database
Return type:

Database