Create, edit, and recalculate Excel spreadsheets with formulas using openpyxl and LibreOffice.
npx skills add https://github.com/tamagusko/linux-cfg --skill xlsx-tamagusko
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/tamagusko/linux-cfg/tree/main/dotfiles/claude/skills/xlsx Command: npx skills add https://github.com/tamagusko/linux-cfg --skill xlsx-tamagusko
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. Run scripts/recalc.py afterward so LibreOffice recalculates all formula values and reports any errors.
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 edits to existing workbooks while preserving their structure.
openpyxl stores formulas as strings but never evaluates them, so cells lack cached values. Recalculate with LibreOffice using scripts/recalc.py, which updates all values and scans every cell for Excel errors.
Run python scripts/recalc.py on the workbook. It returns JSON with an error_summary listing each error type, its count, and exact cell locations like Sheet1!B5, so you can fix and recheck.
Saving a workbook loaded with data_only=True permanently replaces all formulas with their cached values. Only use data_only=True for reading calculated results, never for files you intend to modify and save.
yuyalun-allenEdit spreadsheet files to clean tabular data and verify Excel formulas.
m2ai-portfolioAudit Excel workbooks for formula consistency, source traceability, and data freshness.
devbasexRecord sources for every number, figure, and quotation in business documents.
cellarwoodRead cell values from Google Sheets via the gws CLI.
