Create, edit, and validate Excel workbooks with openpyxl, pandas, and recalc.py.
npx skills add https://github.com/verrio1/vaughn-pai --skill xlsx-verrio1
Please help me install this Agent Skill. Skill: Xlsx Source: https://github.com/verrio1/vaughn-pai/tree/main/skills/Documents/Xlsx Command: npx skills add https://github.com/verrio1/vaughn-pai --skill xlsx-verrio1
This Skill automates the mundane, error-prone handling of Excel workbooks by enabling programmatic creation, editing, and validation of spreadsheets (including formulas) to ensure consistency and accuracy across templates and reports.
Open a workbook with the skill, add a simple SUM formula, save, and run recalc.py to refresh results across all sheets.
High-intent search queries and answers about installing and using this skill.
Automate Excel file creation using openpyxl to programmatically manipulate workbooks, sheets, and formulas. This approach preserves existing formulas and formatting while inserting new data, ensuring consistency across templates and reports.
Recalculate formulas across all sheets using the recalc.py LibreOffice-based tool. This process refreshes formula results and surfaces zero formula errors, ensuring data validation and accuracy throughout the entire workbook.
openpyxl works with pandas to handle data analysis and transformations while updating Excel templates. This combination allows you to manipulate workbook data while preserving formulas and formatting during template updates.
Validate data in financial Excel models by programmatically manipulating formulas and running recalc.py to recalculate results. This process includes safeguards for zero formula errors and preserves template formatting across all sheets.
Build financial models programmatically by using openpyxl to insert formulas into Excel workbooks. This enables automated model creation, sheet management, and formula insertion while maintaining template preservation and formatting consistency.
LibreOffice is required to recalculate Excel formulas via the recalc.py tool. While openpyxl handles workbook manipulation and pandas manages data, LibreOffice provides the engine to refresh formula results across all sheets.
Victory-HugoCreate, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.
zinohomeCreate and validate XLSX workbooks with automated formula recalculation and error checking.
RonaldJENAutomate Excel workbook creation, editing, and analysis with Python.
cf-gbroadyCreate and edit Excel workbooks using pandas, openpyxl, and LibreOffice.
