Create, edit, and recalculate Excel spreadsheets with openpyxl, pandas, and LibreOffice.
npx skills add https://github.com/RavitejaKarra24/dotfiles --skill xlsx-ravitejakarra24
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/RavitejaKarra24/dotfiles/tree/main/agents/.agents/skills/xlsx Command: npx skills add https://github.com/RavitejaKarra24/dotfiles --skill xlsx-ravitejakarra24
High-intent search queries and answers about installing and using this skill.
Use openpyxl to write formula strings directly into cells, such as sheet['B10'] = '=SUM(B2:B9)'. Because openpyxl stores no cached values, run a LibreOffice-based recalculation afterward so the formulas evaluate and readers see actual results.
Use openpyxl when you need formulas, formatting, charts, or cell-level edits; use pandas read_excel and to_excel for bulk data movement in and out of sheets. The two libraries complement each other rather than compete.
openpyxl writes formulas as strings with no cached values, so data_only=True returns None until the file is recalculated. Recalculate the workbook with LibreOffice first, then cached values become readable.
Excel-2007-era functions like SUMIFS, INDEX, MATCH, IFERROR, and SUMPRODUCT work directly. Six newer functions need an _xlfn. prefix (TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS, MINIFS), while XLOOKUP, XMATCH, SORT, FILTER, UNIQUE, and SEQUENCE must be avoided entirely.
Yes, but you must pass keep_vba=True to load_workbook, otherwise the macros are stripped on save. After editing, recalculation still works because LibreOffice reads .xlsm files.
The recalc script refuses when the workbook links to another file and those linked cells have lost cached values, because recalculating would resolve them to #NAME? and delete the links. Copy the values from the original file first, or pass --force to accept the loss.
47networkGenerate Excel-compatible XLSX workbooks from structured data and CSV exports.
Srujan0798Review analyses for methodology, calculations, bias, and readiness, outputting a validation report.
nrakowTrace data lineage across dbt sources, transformations, and reports.
kangminlee-makerEdit and validate Excel workbooks and connected Google Sheets.
