macpie.openpyxltools.worksheet_to_dataframe#

macpie.openpyxltools.worksheet_to_dataframe(ws, num_header: int = 1, num_idx: int = 0)#

Converts an Excel worksheet to a pandas.DataFrame. Better to use pandas.read_excel() as it has more options and is faster.

Parameters:
num_headerint

Number of header rows

num_idxint

Number of index columns