Create, edit, and analyze Excel-compatible spreadsheets with formulas.
npx skills add https://github.com/jr2804/prompts --skill xlsx-jr2804
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/jr2804/prompts/tree/main/skills/documents/xlsx Command: npx skills add https://github.com/jr2804/prompts --skill xlsx-jr2804
This Skill automates spreadsheet creation, editing, and analysis to eliminate tedious manual workbook work.
Use the xlsx skill to generate a basic workbook with a monthly sales table and inline formulas.
High-intent search queries and answers about installing and using this skill.
You can automate Excel formula creation and recalculation by using openpyxl and pandas to generate workbooks, then running the recalc.py script with LibreOffice to ensure formulas stay accurate and current.
Yes, you can update spreadsheet data without overwriting existing Excel formulas; the skill reads and edits workbooks while specifically preserving existing formulas during any data updates or modifications.
Supported spreadsheet formats for automated data analysis and visualization include Excel-compatible files like .xlsx, .xlsm, .csv, and .tsv, allowing you to read, analyze, and visualize data seamlessly.
Yes, you need LibreOffice to recalculate formulas across Excel-compatible files because the skill uses the recalc.py script alongside LibreOffice to process and update formula outputs accurately.
The best way to build a dynamic workbook with inline formulas from scratch is to automate spreadsheet creation using Python-based Excel I/O libraries like openpyxl and pandas to apply formulas and formatting.
Limitations when using Python libraries like openpyxl and pandas to edit Excel files include potential formula evaluation gaps, which is why LibreOffice recalculation is required to guarantee accurate formula outputs.
Wesley1600Executes Python scripts that process CLI input and return JSON-formatted results.
rvdbreemenRepair, clean, convert, and generate XLSX/XLSM/CSV/TSV spreadsheet files.
Science-DiscoveryAutomate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.
Victory-HugoCreate, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.
