xlsx▌

Unless otherwise stated by the user or existing template

Working with Excel files programmatically.

Create, edit, and analyze spreadsheets with formulas, formatting, and data operations. \n \n Supports reading, creating, and modifying .xlsx, .xlsm, .csv, and .tsv files with full formula preservation and recalculation \n Includes financial modeling standards: color-coded text conventions (blue for inputs, black for formulas, green for internal links, red for external links), standardized number formatting, and assumption-based formula construction \n Provides data analysis capabilities via pand

Programmatic Excel spreadsheet creation, editing, and manipulation using openpyxl. \n \n Create and modify .xlsx files with cell data, formulas, formatting, and charts without manual editing \n Supports styling (fonts, fills, borders, alignment), number formatting, conditional formatting, and data validation \n Build charts (bar, line, pie), manage sheets, freeze panes, set column widths, and apply auto-filters \n Cannot execute VBA macros or handle complex pivot tables; some advanced chart type

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and data validation. \n \n Supports reading, creating, and modifying .xlsx, .xlsm, .csv, and .tsv files with full formula preservation and recalculation \n Includes financial modeling standards: color-coded text (blue for inputs, black for formulas, green for internal links, red for external links), currency formatting, and assumption-based formula construction \n Provides data analysis capabilities via pandas for statistics