Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and pandas.
npx skills add https://github.com/vedang/dotagents --skill xlsx-vedang
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/vedang/dotagents/tree/main/skills/xlsx Command: npx skills add https://github.com/vedang/dotagents --skill xlsx-vedang
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 the recalc.py script with LibreOffice to compute values and verify no errors exist.
Use pandas for data analysis, bulk operations, and simple exports via read_excel and to_excel. Use openpyxl when you need formulas, cell formatting, multiple sheets, or editing existing workbooks while preserving their structure.
openpyxl stores formulas as strings without evaluating them. Recalculate with LibreOffice using the recalc.py script, which runs a headless macro to compute all formulas and scans every cell for errors like #REF! and #DIV/0!.
Run recalc.py on the file to get JSON output listing each error type with exact sheet and cell locations. Verify cell references are correct, check denominators before division, and confirm cross-sheet references use the Sheet1!A1 format.
Yes, load the workbook with data_only=True to read cached calculated values. However, never save a workbook opened this way, because doing so permanently replaces all formulas with their static values.
microclawInspect, filter, aggregate, and clean CSV and TSV data with Python.
Duzhenyang111Validate Excel workbooks for formula errors and structural flaws using Python.
claude-office-skillsAnalyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.
CraftOS-devManage Google Sheets data, formatting, and sheets via the API with Node.js.
