otld.utils.openpyxl_utils

Common openpyxl utilities

Functions

add_table(ws, displayName, ref)	Add an Excel table to a worksheet.
delete_empty_columns(worksheet)	Delete columns with all NA/empty values
export_workbook(frames, path[, drop, ...])	Export a dictionary of data frames as an Excel Workbook.
format_openpyxl_worksheet(ws[, skip_cols, ...])	Format openpyxl worksheet.
get_column_names(worksheet)	Get the column names of an Excel worksheet
get_merged_value(worksheet, cell)	Return the value in the first cell of a range of merged cells
long_notes(new_key, footnotes)
set_column_widths(worksheet, column_width)	Set the column widths for an Excel worksheet.