gsolve.core.excel_io

gsolve.core.excel_io#

read_excel_worksheet(excel_file, sheet_name, ...)

Read the excel worksheet sheet_name from excel_file into a DataFrame.

write_excel_worksheet(df, excel_file, sheet_name)

Write DataFrame to excel workbook excel_file in the worksheet sheet_name.

get_excel_worksheets(excel_file, **kwargs)

Return list of all worksheets in excel_file.

get_true_sheet_name(excel_file, sheet_name)

Find sheet_name in excel_file by index or case-insensitive name.

_parse_sheet_name_arg(sheet_name)

Parse and validate sheet_name argument.