xlsx

Create Excel spreadsheets with formulas using openpyxl for file manipulation and pandas for data analysis, generating formatted .xlsx files with calculated cells. The skill automates formula creation and applies professional formatting to your spreadsheet data.

Recalculate Excel formulas and check for errors automatically using the integrated LibreOffice script, ensuring formula accuracy without manual file opening. The recalculation process validates all calculations and verifies the spreadsheet is error-free.

The xlsx skill works with both .xlsx and .csv files, enabling data analysis and manipulation using pandas. It supports creating new files or modifying existing ones while maintaining data integrity across both spreadsheet formats.

Automate financial projection models in Excel by populating assumptions, creating complex formulas with openpyxl, and verifying calculations via LibreOffice recalculation. This approach generates error-free, industry-standard formatted spreadsheet models.

LibreOffice is required as a dependency to perform mandatory formula recalculation and error checking within the xlsx skill workflow. The integrated recalc.py script leverages LibreOffice to validate all spreadsheet calculations.

Pandas reads cell values rather than calculating formulas, requiring the LibreOffice-integrated recalc.py script to execute formula recalculation. The xlsx skill enforces this step to ensure all spreadsheet calculations are processed and verified.