# {py:mod}`ovo.core.utils.export`

```{py:module} ovo.core.utils.export
```

```{autodoc2-docstring} ovo.core.utils.export
:allowtitles:
```

## Module Contents

### Functions

````{list-table}
:class: autosummary longtable
:align: left

* - {py:obj}`write_sheets <ovo.core.utils.export.write_sheets>`
  - ```{autodoc2-docstring} ovo.core.utils.export.write_sheets
    :summary:
    ```
* - {py:obj}`write_sheet <ovo.core.utils.export.write_sheet>`
  - ```{autodoc2-docstring} ovo.core.utils.export.write_sheet
    :summary:
    ```
* - {py:obj}`sanitize_excel_sheet_name <ovo.core.utils.export.sanitize_excel_sheet_name>`
  - ```{autodoc2-docstring} ovo.core.utils.export.sanitize_excel_sheet_name
    :summary:
    ```
* - {py:obj}`shorten_sheet_names <ovo.core.utils.export.shorten_sheet_names>`
  - ```{autodoc2-docstring} ovo.core.utils.export.shorten_sheet_names
    :summary:
    ```
````

### API

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

```{autodoc2-docstring} ovo.core.utils.export.write_sheets
```
````

````{py:function} write_sheet(df: pandas.DataFrame, writer: pandas.ExcelWriter, sheet_name: str = 'Sheet1', index: bool = True, header_format: dict = 'default', **kwargs: typing.Any) -> None
:canonical: ovo.core.utils.export.write_sheet

```{autodoc2-docstring} ovo.core.utils.export.write_sheet
```
````

````{py:function} sanitize_excel_sheet_name(name: str) -> str
:canonical: ovo.core.utils.export.sanitize_excel_sheet_name

```{autodoc2-docstring} ovo.core.utils.export.sanitize_excel_sheet_name
```
````

````{py:function} shorten_sheet_names(names_orig: list[str], max_length: int = 27, max_iter: int = 25) -> list[str]
:canonical: ovo.core.utils.export.shorten_sheet_names

```{autodoc2-docstring} ovo.core.utils.export.shorten_sheet_names
```
````