skills.rest
vivekgoquest
vivekgoquestCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, read, edit, and recalculate Excel .xlsx workbooks and CSVs with openpyxl.

Updated Aug 22, 2026
Search Tags:#reporting#Excel#openpyxl#formulas#spreadsheet#xlsx#csv
One-click install
npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill xlsx-vivekgoquest
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vivekgoquest/hermes-agent-stable/tree/main/skills/productivity/xlsx
Command: npx skills add https://github.com/vivekgoquest/hermes-agent-stable --skill xlsx-vivekgoquest

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve? Working with Excel files programmatically is error-prone: openpyxl never evaluates formulas, plain row inserts break references, and charts get dropped on re-save. This Skill provides tested CLI scripts that handle workbook creation, inspection, editing, reference-aware restructuring, and CSV conversion without those traps. ## Core Features & Use Cases - Workbook creation from JSON specs: Build multi-sheet workbooks with styling, formulas, charts, conditional formatting, data validation, native tables, defined names, hyperlinks, and notes. - Reading and editing: Dump sheets as JSON or CSV, list formulas with cached values, set cells, append rows, and restructure rows/columns with automatic formula-reference rewriting across all sheets. - Headless recalculation and CSV interop: Recalculate formulas via LibreOffice and convert between CSV and styled xlsx with type inference and explicit encodings. - Use Case: Generate a monthly sales report workbook with a formatted summary sheet, a chart, and formulas, then recalculate it headlessly and export the data sheet to CSV for downstream import. ## Quick Start Ask the agent to create an Excel report from your data using the xlsx skill, for example: "Create a styled xlsx workbook with two sheets, a SUM formula, and a bar chart from this CSV."

Frequently Asked Questions about xlsx

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an Excel xlsx file with Python openpyxl?▼

Write a JSON spec describing sheets, rows, styles, formulas, charts, and tables, then run xlsx_create.py spec.json out.xlsx. The script builds the workbook with openpyxl and prints a JSON summary of the created sheets.

How to convert CSV to Excel with type inference?▼

Run csv_to_xlsx.py data.csv out.xlsx to convert a CSV into a styled workbook. It infers int, float, bool, and ISO date types per cell, bolds the header row, freezes the top row, and adds an autofilter.

Why do openpyxl formulas show None instead of calculated values?▼

openpyxl never evaluates formulas; cached results only exist if the file was last saved by Excel or LibreOffice. Run xlsx_recalc.py to recalculate headlessly via LibreOffice, then read with --data-only.

Does inserting rows in openpyxl update formula references?▼

No, plain openpyxl insert_rows and delete_cols do not shift formula references, merges, or tables. Use xlsx_restructure.py, which rewrites references on all sheets and reports anything it could not shift.

Can this skill edit legacy .xls files?▼

No, the legacy binary .xls format is not supported. Convert it first with LibreOffice using soffice --headless --convert-to xlsx old.xls, then work with the resulting .xlsx file.

Is xlsx sheet protection secure for confidential data?▼

No, sheet protection is only an integrity signal, not security. The protection hash can be stripped by editing the zip XML or unchecking it in LibreOffice, and it encrypts nothing.

Related Skills

Explore More Data & Analytics Skills→
hivgb1-aihivgb1-ai

csv-clean

Detect and fix CSV data quality issues including subtotal rows, formatted numbers, and mixed date formats.

Community
Intermediate
opensquillaopensquilla
6.8k

meta-multi-format-export-pack

Renders one source content into docx, pptx, xlsx, and PDF deliverables.

Official
Intermediate
autonomous-aiautonomous-ai
465

sheetsdoc

Generate editable DOCX reports, formula-driven XLSX workbooks, and PDF previews from structured JSON source.

Official
Advanced
omicverseomicverse
32

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

Official
Intermediate