xlsx

Automates Excel (.xlsx/.csv) workbook creation, editing, analysis with formulas and recalc.py verification.

2|Updated Oct 29, 2025

Search Tags:#pandas #openpyxl #formulas #excel #data-analysis #xlsx #recalc

Ready to run

npx skills add https://github.com/shanelindsay/agentic-r --skill xlsx-shanelindsay

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/shanelindsay/agentic-r/tree/main/skills/scientific-thinking/document-skills/xlsx
Command: npx skills add https://github.com/shanelindsay/agentic-r --skill xlsx-shanelindsay

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheet workflows for Excel (.xlsx/.csv) that require reliable creation, editing, and analysis with strict formula integrity and reproducible outputs.

Core Features & Use Cases

Create, edit, and format Excel workbooks with formulas
Recalculate formulas across sheets using recalc.py and verify no errors
Generate diffable outputs and structured data for reporting and auditing
Use cases include financial modeling, data analysis, and template-driven reporting

Quick Start

Create or modify an Excel workbook, apply formulas, and recalculate to ensure error-free results.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel spreadsheet creation with formulas and formatting?▼

Automate Excel spreadsheet creation by applying formulas and formatting programmatically to generate reproducible, diffable outputs for financial modeling and reporting tasks.

What's the best way to recalculate Excel formulas across multiple sheets?▼

Recalculate Excel formulas across sheets using recalc.py to verify zero formula errors and ensure strict formula integrity for reproducible data processing outputs.

How do I generate diffable outputs from xlsx files for auditing?▼

Generate diffable outputs and structured data from xlsx files by applying strict documentation and formatting standards to support reliable reporting and auditing workflows.

Does this approach work with pandas and openpyxl for data analysis?▼

Excel automation and analysis workflows integrate with pandas and openpyxl to handle data processing, formula application, and structured reporting for data analysis tasks.

Can I use Excel automation for financial modeling and template-driven reporting?▼

Excel automation supports financial modeling and template-driven reporting by creating, editing, and formatting workbooks with formulas while ensuring zero formula errors through recalculation.

Why does Excel formula recalculation fail and how do I verify no errors?▼

Excel formula recalculation errors are verified and resolved using recalc.py, which checks formulas across sheets to ensure zero errors and produce reproducible, structured outputs.