skills.rest
shanelindsay
shanelindsayCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/shanelindsay/agentic-r --skill xlsx-shanelindsay
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
GayanKavindaGayanKavinda

xlsx

Create, edit, and repair spreadsheet files from raw tabular data.

Community
Advanced
jaypatrickjaypatrick

spreadsheet

Automate spreadsheet workbook creation, editing, and analysis with formulas using openpyxl and pandas.

Community
Intermediate
thimsluggathimslugga

spreadsheet

Automate spreadsheet creation, editing, and analysis with openpyxl and pandas.

Community
Intermediate
mrdonleemrdonlee

xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced