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