Xlsx

This handles spreadsheet operations through openpyxl and pandas, with a strong emphasis on financial modeling conventions. The documentation is thorough about color coding standards (blue for inputs, black for formulas, green for internal links), number formatting rules, and crucially, it enforces using Excel formulas instead of hardcoding calculated values in Python. It includes a recalc.py script that uses LibreOffice to evaluate formulas and scan for errors like #REF! and #DIV/0!. The workflow is read data with pandas, build structure and formulas with openpyxl, then recalculate to get actual values. If you're building financial models or any spreadsheet where formulas matter, the detailed standards and error checking are worth following.