Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/ludotype/game-adventurertown --skill xlsx-ludotype
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ludotype/game-adventurertown/tree/main/.agent/skills/xlsx Command: npx skills add https://github.com/ludotype/game-adventurertown --skill xlsx-ludotype
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings like '=SUM(B2:B9)' directly into cells, then save the workbook. Formulas are stored but not evaluated, so run scripts/recalc.py afterward to compute values with LibreOffice and verify no errors exist.
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 edits to existing files while preserving their structure.
openpyxl stores formulas as strings without evaluating them. Run scripts/recalc.py on the file, which uses LibreOffice headless to recalculate all formulas and reports any Excel errors as JSON with cell locations.
Run scripts/recalc.py to get a JSON error_summary listing each error type with cell locations like Sheet1!B5. Fix invalid references, guard divisions against zero denominators, then recalculate again until status is success.
Load with load_workbook('file.xlsx', data_only=True) to read cached calculated values. Never save from a data_only workbook, because doing so permanently replaces all formulas with their static values.
yuyalun-allenEdit spreadsheet files to clean tabular data and verify Excel formulas.
matlee0409Create headless PowerPoint decks with numbers bound to Excel workbook cells.
jonnytacos8Validate financial figures and cross-check totals against rag_search context.
alexaundreProcess and produce .xlsx, .xlsm, .csv, and .tsv spreadsheet files with formulas and validation.
