Create and edit Excel spreadsheets with formulas and formatting using pandas and openpyxl.
npx skills add https://github.com/cpalumbo/cinzia-claude --skill xlsx-cpalumbo
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/cpalumbo/cinzia-claude/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/cpalumbo/cinzia-claude --skill xlsx-cpalumbo
Spreadsheets are central to planning, reporting, and analysis, but creating, updating, and validating complex workbooks while preserving formulas and templates is error-prone and time-consuming.
Use the skill to create a new spreadsheet, populate a small data table, and add a formula like =SUM(B2:B10) to verify that formulas recalculate automatically and templates are respected.
High-intent search queries and answers about installing and using this skill.
To create Excel spreadsheets with formulas and formatting, this skill leverages Python openpyxl and pandas to populate data tables, apply consistent styling, and enforce formula-based calculations like SUM functions without hardcoding values.
Yes, you can update an existing Excel template without breaking formulas, as the skill performs template-aware updates that preserve existing workbook conventions, structure, and formula-based calculations while modifying content.
Spreadsheet formula recalculation when using openpyxl is handled through a LibreOffice-based validation workflow, which processes the generated workbook to ensure formulas recalculate automatically and outputs verified results.
The best way to build a financial model and dashboard from a dataset is using this skill to populate data tables, apply enforced formula calculations for totals, and generate dashboard snapshots with consistent template styling.
Yes, spreadsheet generation with pandas and openpyxl supports data analysis across multiple sheets, allowing you to perform cross-sheet data visualization, apply consistent document formatting, and maintain template structure.
You should avoid hardcoding values in spreadsheet formulas because this skill enforces formula-based calculations to maintain calculation integrity, ensure accurate data analysis, and preserve template structures during automated workbook updates.
guiledoCreate and edit Excel workbooks from CSV data with formulas and formatting.
KILWA73Read, clean, transform, and export XLSX, CSV, and TSV files.
POBIMRecalculate and validate formulas in Excel workbooks across spreadsheet formats.
Razaib-khanCreate and edit Excel spreadsheets with formulas, formatting, and validation workflows.
