ovo.core.utils.export

Module Contents

Functions

write_sheets
write_sheet	Write df as an excel file to ExcelWriter, roughly similar to df.to_excel except that it handles df with MultiIndex columns and index=False.
sanitize_excel_sheet_name
shorten_sheet_names

API

ovo.core.utils.export.write_sheets(df_dict: dict[str, pandas.DataFrame], fd_or_path: io.BytesIO | str, header_format: dict | None = 'default')

ovo.core.utils.export.write_sheet(df: pandas.DataFrame, writer: pandas.ExcelWriter, sheet_name: str = 'Sheet1', index: bool = True, header_format: dict = 'default', **kwargs: Any) → None

Write df as an excel file to ExcelWriter, roughly similar to df.to_excel except that it handles df with MultiIndex columns and index=False.

ovo.core.utils.export.sanitize_excel_sheet_name(name: str) → str

ovo.core.utils.export.shorten_sheet_names(names_orig: list[str], max_length: int = 27, max_iter: int = 25) → list[str]