read_sheet

dscat.dictionary.read_sheet(path, sheet, max_rows=None)

Read a worksheet as rows of cleaned string cells.

Parameters:

• path (pathlib.Path) – Path to the .xlsx dictionary.

• sheet (str) – Worksheet name.

• max_rows (int, optional) – Stop after this many rows; None reads the whole sheet.

Returns:

One list of stripped string cells per row.

Return type:

list of list of str