Create, edit, and recalculate Excel workbooks with openpyxl, pandas, and LibreOffice.
npx skills add https://github.com/Immortalqx/my_codex_skills --skill xlsx-immortalqx
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/Immortalqx/my_codex_skills/tree/main/xlsx Command: npx skills add https://github.com/Immortalqx/my_codex_skills --skill xlsx-immortalqx
.xlsx, .xlsm, .csv, and .tsv files while preserving formulas, formatting, and multi-sheet structure. ## Core Features & Use Cases - Structure-preserving editing: Uses openpyxl to modify existing workbooks without losing formulas, named sheets, comments, or formatting. - Formula-first rule: Enforces writing real Excel formulas (e.g., =SUM(B2:B9)) instead of hardcoding Python-computed values. - Automated recalculation and error scanning: The bundled scripts/recalc.py drives LibreOffice headless to recalculate formulas and reports #REF!, #DIV/0!, #VALUE!, and other errors as JSON with cell locations. - Use Case: You receive a messy CSV export and need a formatted financial workbook with assumption cells, computed columns, and a summary sheet. The Skill builds it with openpyxl, keeps inputs visually distinct from outputs, and verifies the file recalculates cleanly before handoff. ## Quick Start Use the xlsx skill to turn this CSV into a formatted Excel workbook with real formulas and verify it recalculates without errors.High-intent search queries and answers about installing and using this skill.
Use openpyxl's load_workbook to open the existing file, which preserves formulas, formatting, named sheets, and comments. Make your edits on the worksheet objects and save, then recalculate with LibreOffice to confirm formulas still resolve correctly.
Use openpyxl when workbook structure, formulas, styling, or multiple sheets must be preserved. Use pandas for data cleaning, joins, aggregation, and reshaping, then write the final output with openpyxl if formulas or formatting matter.
Run the bundled recalc.py script, which drives LibreOffice headless with a Basic macro that calls calculateAll and saves the file. It returns JSON with total formula count and any Excel errors found per cell.
#REF! appears when row or column edits invalidate formula references, and #DIV/0! occurs when a denominator can be zero. The recalc.py script scans all sheets and reports each error type with its sheet and cell location so you can fix them.
Yes, the workflow covers .xlsx, .xlsm, .csv, and .tsv files. CSV and TSV data is typically loaded with pandas for cleaning and reshaping, then written out as a formatted Excel workbook when structure or formulas are needed.
brainbrewlabsProfile and clean tabular datasets, then write a cleaned file with a change report.
IeerCreate, edit, and validate Excel workbooks from CSV/JSON inputs.
jonnytacos8Validate financial figures and cross-check totals against rag_search context.
vikingokftInsert rows into a Google Sheets spreadsheet using the gws tool.