merton.excel.sample

Programmatic sample workbook for the Excel integration.

Generates a multi-sheet .xlsx with worked examples of every =MERTON_* formula. Users open the workbook after sideloading the add-in (merton excel install); the formulas then evaluate against their local server.

The function uses openpyxl so the file is fully native Excel — formulas, formatting, headers, the lot — and works in Excel for the web without recalculation surprises.

Functions

write_sample_workbook(→ pathlib.Path)

Write a worked-example workbook to path and return the path.

Module Contents

merton.excel.sample.write_sample_workbook(path: str | pathlib.Path) → pathlib.Path

Write a worked-example workbook to path and return the path.