Create and edit Excel workbooks with formulas and formatting via Python.
npx skills add https://github.com/smorand/claude-config --skill xlsx-smorand
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/smorand/claude-config/tree/main/skills/xlsx Command: npx skills add https://github.com/smorand/claude-config --skill xlsx-smorand
This Skill automates Excel workbook creation, editing, and analysis, enabling deterministic formula handling, template preservation, and standardized formatting to save time and reduce errors.
Create a new workbook with a SUM formula and apply blue inputs, then recalculate to verify zero errors.
High-intent search queries and answers about installing and using this skill.
Automate Excel workbook creation by using openpyxl and pandas to build formulas, apply formatting, and recalculate via the recalc.py utility to ensure zero formula errors and consistent financial modeling standards.
Yes, you can modify templates while preserving conventions and styles. The Skill handles template preservation by maintaining existing formulas and applying standardized color coding and number formats throughout edits.
Run the dedicated recalculation utility with LibreOffice to detect common Excel errors and verify formula accuracy. This ensures reliable recalculation and catches zero-formula-error requirements before deployment.
Use pandas and openpyxl to read and analyze data across all sheets in a workbook. Both libraries enable efficient data extraction, manipulation, and analysis while maintaining formula integrity during processing.
Yes, the Skill applies financial model standards including color coding for inputs and consistent number formats. It enforces Excel formatting conventions and mandates formula-based calculations orchestrated by Python.
Yes, perform data analysis and visualization while automating formula recalculation through recalc.py and LibreOffice. This enables deterministic calculations and standardized outputs for reporting workflows.
dp-archiveAutomate spreadsheet creation, editing, analysis, and formatting for .xlsx, .csv, and .tsv files.
GongXLiangCreate, edit, and analyze Excel workbooks with formulas and formatting.
kwoekelEdit Excel workbooks while preserving formulas, formatting, and multi-tab integrity.
RonaldJENAutomate Excel workbook creation, editing, and analysis with Python.
