Create, edit, and validate Excel spreadsheets with formulas and formatting.
npx skills add https://github.com/MoonBoi9001/claude-code-cli-tools --skill xlsx-moonboi9001
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/MoonBoi9001/claude-code-cli-tools/tree/main/skills/xlsx Command: npx skills add https://github.com/MoonBoi9001/claude-code-cli-tools --skill xlsx-moonboi9001
Working with Excel spreadsheets manually is error‑prone and time‑consuming, especially when you need to preserve formulas, maintain professional formatting, or clean messy data.
=SUM, =AVERAGE, etc.) instead of hard‑coded values.scripts/recalc.py to recompute all formulas and detect errors.Ask the xlsx skill to open and clean the spreadsheet "budget‑2025.xlsx" and save the corrected file.
High-intent search queries and answers about installing and using this skill.
To clean a messy CSV and convert it to a formatted Excel spreadsheet, the skill uses pandas to read and validate data, then applies openpyxl to enforce professional formatting and formula-first logic before saving as a styled XLSX workbook.
To preserve Excel formulas when editing spreadsheets, the skill enforces formula-first editing by injecting actual Excel formulas like SUM and AVERAGE rather than static values, ensuring calculations remain dynamic and accurate.
Yes, you need LibreOffice to recalculate formulas in an XLSX file, as the skill utilizes a dedicated recalc.py script to execute LibreOffice for recomputing all formulas and detecting errors automatically.
Yes, you can use pandas and openpyxl to apply financial formatting to a data model, as the skill enforces specific font, color-coding, and number-format standards required for professional financial spreadsheet models.
The best way to convert XLSX to TSV or CSV while maintaining data integrity is using the skill's integrated pandas snippets, which read, analyze, and write spreadsheet files across formats while validating data structure accurately.
cbbkrd-techCreate, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.
Xueheng-LiConvert messy tabular inputs into validated Excel workbooks with working formulas.
marcusfelixCreate and edit Excel .xlsx files with pandas and openpyxl.
sergeyitalyCreate, edit, and analyze Excel files with openpyxl and pandas.