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 usepandas.read_excel()
as it has more options and is faster.- Parameters:
- num_headerint
Number of header rows
- num_idxint
Number of index columns