Create, edit, and analyze Excel spreadsheets with formulas, formatting, and recalculation.
npx skills add https://github.com/Clay-HHK/claude-skills --skill xlsx-clay-hhk
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Clay-HHK/claude-skills/tree/main/xlsx Command: npx skills add https://github.com/Clay-HHK/claude-skills --skill xlsx-clay-hhk
High-intent search queries and answers about installing and using this skill.
Use openpyxl to create a workbook and assign formula strings like '=SUM(B2:B9)' directly to cells, then save the file. Always use Excel formulas instead of hardcoding Python-calculated values so the spreadsheet recalculates when source data changes.
Use pandas for data analysis, bulk operations, and simple exports with pd.read_excel and df.to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or editing existing files while preserving their structure.
openpyxl saves formulas as strings without computed values, so run the recalc.py script which uses LibreOffice headless to recalculate all formulas. It returns JSON with error counts and cell locations for any #REF!, #DIV/0!, or similar errors.
#REF! occurs from invalid cell references and #DIV/0! from dividing by empty or zero cells. Verify cell references, check denominators before division, and run recalc.py to get exact error locations by sheet and cell.
Yes, load the workbook with data_only=True to read cached calculated values. However, never save a file opened this way, because formulas will be permanently replaced with their static values.
microclawInspect, filter, aggregate, and clean CSV and TSV data with Python.
Soham407Generate MARP slide decks with SVG charts and interactive HTML sections.
HKU-MMLabAnalyzes tender pricing, spreadsheet totals, and vendor financial tradeoffs from local files.
pymc-labsRun Python notebooks with reactive cell execution on dependencies.
