Create, edit, and analyze Excel workbooks with formulas and formatting.
npx skills add https://github.com/amrhas82/agentic-toolkit --skill xlsx-amrhas82
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/amrhas82/agentic-toolkit/tree/main/ai/subagents/claude/skills/xlsx Command: npx skills add https://github.com/amrhas82/agentic-toolkit --skill xlsx-amrhas82
This Skill eliminates manual spreadsheet work, enabling comprehensive creation, editing, and analysis of Excel files. It ensures dynamic, error-free spreadsheets with proper formatting and formula recalculation, saving countless hours in data processing and report generation.
#REF! or #DIV/0!, ensuring data integrity and reliable financial models.Create a new Excel file named 'quarterly_sales.xlsx' with two sheets: 'Sales Data' containing columns 'Product', 'Q1', 'Q2', 'Q3', 'Q4', and 'Summary' with a formula to sum Q1-Q4 sales for each product.
High-intent search queries and answers about installing and using this skill.
Automate spreadsheet creation using openpyxl and pandas to generate Excel files with dynamic formulas, precise numeric formatting, and color standards. The Skill handles formula preservation and recalculation through LibreOffice integration, ensuring accurate outputs without manual editing.
Yes. Read and analyze existing spreadsheets with pandas and openpyxl while preserving all formulas and formatting. The Skill maintains formula integrity during data modifications, preventing common errors like broken references that occur with manual edits.
The Skill automatically recalculates formulas and verifies them for errors like #REF! or #DIV/0! using the recalc.py workflow integrated with LibreOffice. This zero-error verification ensures financial models and reports contain reliable, up-to-date calculations.
Create financial models by combining pandas for data handling, openpyxl for formula construction, and LibreOffice recalculation for dynamic updates. The Skill automates template setup, scenario modifications, and output generation while maintaining formula accuracy across complex workbooks.
Yes. The Skill requires you to design Excel formulas explicitly rather than hardcoding values. It automates formula application, recalculation, and error verification, but formula logic and structure come from your specifications.
Use this Skill when you need repeatable, error-free spreadsheet generation at scale—financial reporting, data analysis with complex formulas, template updates, or scenario planning. Manual work is eliminated through automated creation, modification, and recalculation workflows.
Blake-JohnProcess and convert spreadsheet data across .xlsx, .xlsm, .csv, and .tsv files.
skkarkiAutomate Excel workbook creation, editing, and analysis across XLSX, XLSM, CSV, and TSV formats.
RonaldJENAutomate Excel workbook creation, editing, and analysis with Python.
XJTLUmediaCreate and edit Excel spreadsheets with openpyxl, pandas, and LibreOffice.