Read, create, edit, and validate Excel files via Office Open XML.
npx skills add https://github.com/haojing8312/WorkClaw --skill xlsx-haojing8312
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/haojing8312/WorkClaw/tree/main/apps/runtime/src-tauri/builtin-skills/xlsx Command: npx skills add https://github.com/haojing8312/WorkClaw --skill xlsx-haojing8312
Managing Excel workbooks often leads to format loss, broken formulas, and inconsistent styling when files are edited programmatically. This Skill eliminates those issues by handling spreadsheets directly through the Office Open XML format, preserving every detail while automating read, edit, creation, and validation tasks.
READ – Analyze existing data with pandas without altering the source file.
CREATE – Build new workbooks from a minimal XML template, ensuring all calculated cells are real Excel formulas.
EDIT – Modify cells, add columns, insert rows, or repair formulas using XML unpack‑edit‑pack flow, maintaining original sheets and styles.
VALIDATE – Run static formula checks and optional LibreOffice recalculation to catch errors before delivery.
Use case: A financial analyst can update a quarterly budget workbook, insert new expense rows, and automatically recalculate totals while keeping the original formatting intact.
Ask the xlsx skill to generate a new budget workbook named 'FY2025_Budget.xlsx' with calculated totals.
High-intent search queries and answers about installing and using this skill.
To validate Excel formulas, this Skill runs static formula checks and optional LibreOffice recalculation to catch errors before delivery. This validation mechanism ensures calculated cells function correctly without needing manual review.
To create new Excel workbooks, this Skill builds files from a minimal XML template while ensuring all calculated cells are real Excel formulas. This creation process generates structured .xlsx or .xlsm files suitable for financial modeling.
Yes, you need a Python environment with pandas installed to use this Skill. The dependency on pandas is required to read and analyze existing spreadsheet data, while custom XML scripts handle the creation and editing of Office Open XML formats.
Yes, this tool supports csv and tsv formats for data analysis. It reads, creates, edits, and validates spreadsheet files across .xlsx, .xlsm, .csv, and .tsv formats to facilitate financial modeling and report generation.
mattmacleod16-svgAutomate spreadsheet creation, editing, analysis, and formatting with openpyxl and pandas.
soq123Generate and format Excel workbooks with formulas, charts, and pivot summaries using Python.
patriotnewsactivismGenerate Excel spreadsheets with formatting, formulas, charts, and data validation.
augustsclCreate, edit, and validate xlsx workbooks via XML templates.
