otld.utils.openpyxl_utils.get_column_names

otld.utils.openpyxl_utils.get_column_names(worksheet: Worksheet) → list[str]

Get the column names of an Excel worksheet

This function iterates through the rows in an Excel worksheet until all columns have a non-empty value and then returns these as candidate column names.

Args:

worksheet (Worksheet): An Excel worksheet.

Returns:

list[str]: A list of potential column names