Create, read, edit, and recalculate Excel .xlsx workbooks and CSVs with openpyxl.
npx skills add https://github.com/ewtodd/son-of-anton --skill xlsx-ewtodd
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/ewtodd/son-of-anton/tree/main/skills/productivity/xlsx Command: npx skills add https://github.com/ewtodd/son-of-anton --skill xlsx-ewtodd
xlsx_create.py. - Inspection and Editing: Dump sheets as JSON or CSV, list formulas with cached values, edit cells, append rows, manage tables and defined names with xlsx_read.py and xlsx_edit.py. - Reference-Aware Restructuring: Insert or delete rows and columns while automatically rewriting formula references, merges, tables, and defined names across all sheets using xlsx_restructure.py. - Use Case: Generate a styled quarterly sales report with formulas and charts from a JSON spec, then recalculate it headlessly with LibreOffice so cached values are available for downstream reading. ## Quick Start Ask the agent to create an Excel workbook from a JSON spec using the xlsx skill's scripts, for example to build a styled sales report with formulas and a chart.High-intent search queries and answers about installing and using this skill.
Write a JSON spec defining sheets, rows, formulas, charts, and styling, then run xlsx_create.py with the spec and output path. Set full_calc_on_load so Excel or LibreOffice recalculates formulas when the file opens, since openpyxl never evaluates them.
Run xlsx_recalc.py, which shells out to LibreOffice headlessly to open, recalculate, and re-save the workbook so cached values become available. If soffice is not installed, it prints a JSON response with recalculated set to false and installation guidance.
Plain openpyxl insert_rows and delete_cols do not shift formula references, merges, or table ranges. Use xlsx_restructure.py instead, which rewrites references across all sheets, though chart anchors, images, and conditional-format rule formulas still cannot be shifted.
No, openpyxl never computes formulas. Cached results are only available via data_only=True when the file was last saved by Excel or LibreOffice; files written by openpyxl return None until recalculated by a real spreadsheet application.
Legacy .xls files must first be converted with LibreOffice using soffice --headless --convert-to xlsx. CSV files convert directly via csv_to_xlsx.py with type inference for numbers, booleans, and ISO dates, plus configurable encoding and delimiter.
No, sheet protection set via --protect is only an editing signal, not security. Anyone can strip it by editing the zip XML or unchecking it in LibreOffice, so never rely on it for confidentiality or integrity.
metric-space-aiNormalizes CSV, Excel, SQL, and JSON tabular sources into a structured SQLite-backed discovery graph with projections.
opensquillaRenders one source content into docx, pptx, xlsx, and PDF deliverables.
blueskies1818Generate PowerPoint decks from Excel data using python-pptx.
Mo7amed-MahmoudGenerate and modify Excel workbooks with Python libraries.