skills.rest
igniteenow
igniteenowCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, read, and edit Excel workbooks with formulas, formatting, and recalculation.

16|Updated Sep 22, 2026
Search Tags:#Excel#openpyxl#formulas#spreadsheet#xlsx#csv#recalculation
One-click install
npx skills add https://github.com/igniteenow/robo --skill xlsx-igniteenow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/igniteenow/robo/tree/main/skills/productivity/xlsx
Command: npx skills add https://github.com/igniteenow/robo --skill xlsx-igniteenow

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Spreadsheet work often breaks down on formula errors, lost cached values, and formatting inconsistencies when files are generated programmatically. This Skill produces Excel workbooks whose formulas actually evaluate, whose conventions match the original file, and whose numbers can be verified before delivery. ## Core Features & Use Cases - Workbook creation and editing: Build or modify .xlsx, .xlsm, .xltx, .csv, and .tsv files using openpyxl and pandas, with formulas written as live expressions rather than hardcoded results. - Mandatory formula recalculation: The bundled recalc.py script drives LibreOffice to compute every formula, rewrites the file in place, and reports JSON error summaries naming the exact cells that failed. - Financial modeling conventions: Standard color coding, number formats, and assumption-cell structure for models, with an optional excel-author skill for investment-banking standards. - Use Case: A user asks for a revenue projection model with growth assumptions. The Skill writes labeled input cells, consistent formulas across periods, recalculates the workbook, confirms zero errors, and spot-checks computed values before handing the file back. ## Quick Start Ask the agent to create an Excel workbook from your data with formulas and formatting, for example: build a quarterly budget spreadsheet from these numbers with a SUM total row.

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 file with formulas in Python?▼

Use openpyxl to write formulas as strings, such as sheet['B10'] = '=SUM(B2:B9)', rather than Python-computed values. Then recalculate the file with LibreOffice so formula cells hold cached values that pandas and previewers can read.

openpyxl vs pandas for Excel files, which should I use?▼

Use openpyxl when you need formulas, formatting, charts, or cell-level edits; use pandas read_excel and to_excel for bulk data movement. Reading a model with both formulas and values requires two openpyxl load_workbook passes.

Why do openpyxl formulas show None when read back?▼

openpyxl writes formulas without cached values, so data_only=True returns None until the file is recalculated. Run the recalc.py script, which uses LibreOffice to compute every formula and rewrite the file in place.

Which Excel functions work with LibreOffice recalculation?▼

Excel-2007-era functions like SUMIFS, INDEX, MATCH, IFERROR, and SUMPRODUCT work directly. Six newer functions need an _xlfn. prefix, while XLOOKUP, XMATCH, SORT, FILTER, UNIQUE, and SEQUENCE should be avoided entirely.

Can openpyxl edit xlsm files without losing macros?▼

Yes, but you must pass keep_vba=True to load_workbook, otherwise the macros are stripped on save. The markitdown tool can also read .xlsm files for a quick content overview.

Why does recalculation refuse to run on some workbooks?▼

recalc.py refuses when a workbook links to an external file whose cached values were stripped by an openpyxl save, since recalculating would resolve those links to #NAME? and delete them. Copy the linked values from the original first, or pass --force to accept the loss.

Related Skills

Explore More Data & Analytics Skills→
iterationlayeriterationlayer
2

sheet-generation-api

Generate CSV, Markdown, and XLSX spreadsheets from structured JSON input.

Official
Advanced
Quill-AgentQuill-Agent
3

pptx-author

Create PowerPoint presentations from Excel workbooks using python-pptx.

Community
Intermediate
open-nekoopen-neko
11

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

Official
Advanced
petobenspetobens

google-sheets

Create, read, edit, and format Google Sheets through the gws CLI.

Community
Advanced