Create, edit, and recalculate Excel spreadsheets with openpyxl, pandas, and LibreOffice.
npx skills add https://github.com/amirbiron/claude-skills --skill xlsx-amirbiron
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/amirbiron/claude-skills/tree/main/skills/xlsx Command: npx skills add https://github.com/amirbiron/claude-skills --skill xlsx-amirbiron
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formulas as strings, such as sheet['B10'] = '=SUM(B2:B9)', rather than hardcoding computed values. After saving, recalculate the file with LibreOffice so formula cells contain cached values that other tools can read.
Use openpyxl when you need formulas, formatting, or cell-level edits; use pandas read_excel and to_excel for bulk data movement. For a quick look at sheet contents, markitdown renders each sheet without cell coordinates.
openpyxl writes formulas as strings with no cached values, so data_only=True returns None until the file is recalculated. Run a LibreOffice-based recalculation pass to compute and store the values.
Post-2007 functions like TEXTJOIN, IFS, and MAXIFS need an _xlfn. prefix, while XLOOKUP, XMATCH, SORT, FILTER, UNIQUE, and SEQUENCE cannot be evaluated at all. Prefer Excel-2007-era functions such as SUMIFS, INDEX, MATCH, and IFERROR.
Macros in .xlsm files survive only if you pass keep_vba=True to load_workbook. External links lose their cached values on save, so copy those cell values from the original file before recalculating or the links resolve to #NAME?.
47networkGenerate Excel-compatible XLSX workbooks from structured data and CSV exports.
2nth-aiBuild budgets, forecasts, and scenario models for business financial planning.
jinming99Cross-verify concern sheet YAML against review and paper PDFs.
CDataSoftwareQuery and manipulate Google Sheets data via CData Connect AI.
