Create and edit Excel spreadsheets with formulas and formatting.
npx skills add https://github.com/tkhongsap/ai-dev-workflow --skill xlsx-tkhongsap
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/tkhongsap/ai-dev-workflow/tree/main/.claude/skills/xlsx Command: npx skills add https://github.com/tkhongsap/ai-dev-workflow --skill xlsx-tkhongsap
What problem does it solve? This Skill automates complex spreadsheet tasks, from creation and data analysis to formula recalculation and error correction, ensuring accuracy and saving significant manual effort in financial modeling and data reporting.
Core Features & Use Cases:
.xlsx files while preserving formatting and formulas.Quick Start: Use the xlsx skill to create a new spreadsheet named 'quarterly_sales.xlsx' with columns for 'Product', 'Q1 Sales', 'Q2 Sales', 'Q3 Sales', 'Q4 Sales', and a 'Total Sales' column that sums the quarterly sales.
High-intent search queries and answers about installing and using this skill.
Use this Skill to generate new `.xlsx` files with dynamic formulas that calculate automatically. It writes Excel formulas directly into cells, preserving them when the spreadsheet is opened and recalculated in LibreOffice, ensuring accuracy without manual value entry.
Yes. This Skill uses LibreOffice to recalculate all formulas automatically and validate them for errors, enforcing zero formula errors in your output and catching calculation issues before the spreadsheet is shared.
This Skill reads `.xlsx` files, analyzes and updates their data, and preserves existing formulas and templates. It applies industry-standard color conventions and number formatting, so your modifications maintain the original workbook structure.
This Skill automates financial reporting by creating `.xlsx` files with dynamic formulas for totals and subtotals, color-coded assumptions, and error-checked calculations. It outputs production-ready reports without manual formula entry or recalculation.
Yes. LibreOffice with the recalc.py module is required for mandatory formula recalculation and validation. The Skill depends on pandas and openpyxl for data analysis and spreadsheet manipulation alongside LibreOffice's calculation engine.
This Skill identifies and validates formulas using LibreOffice recalculation, flagging errors so you can correct them. It does not auto-repair broken formulas, but ensures all formulas are error-free before output.
CHENyiru3Automate reading, cleaning, restructuring, and formatting of spreadsheet files.
CleanExpoGenerate tax optimization reports and export them as Word, Excel, and PDF files.
Science-DiscoveryAutomate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.
RonaldJENAutomate Excel workbook creation, editing, and analysis with Python.