skills.rest
szweibel
szweibelCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas and templates.

2|2|Updated Nov 6, 2025
Search Tags:#pandas#formulas#excel#xlsx#recalc
One-click install
npx skills add https://github.com/szweibel/claude-skills --skill xlsx-szweibel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/szweibel/claude-skills/tree/main/xlsx
Command: npx skills add https://github.com/szweibel/claude-skills --skill xlsx-szweibel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas.

What problem does it solve?

Automate creation, editing, analysis, and maintenance of Excel workbooks while preserving formulas and templates, reducing manual spreadsheet toil and ensuring consistent outputs.

Core Features & Use Cases

  • Formula integrity & templates: enforce zero formula errors and preserve existing templates when updating files.
  • Data analysis with pandas: read, analyze, and export data across multiple sheets.
  • Formula recalculation: trigger LibreOffice-based recalculation to refresh values in all cells.
  • Best-practice guidance: encourage using Excel formulas over hard-coded calculations and maintain proper documentation for hardcoded data.
  • Use Case: generate a scenario-based workbook with multiple sheets, formulas, and versioned outputs, then recalculate to verify results.

Quick Start

Create a new workbook with a simple sum formula, then recalculate to verify 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 workbook creation with formulas instead of hardcoding values?▼

Automate Excel workbook creation by using openpyxl and pandas to build spreadsheets with formulas, then trigger recalculation to refresh all cell values. This ensures consistent outputs and eliminates manual formula entry while preserving template structure.

Can I read and analyze data from multiple sheets in an Excel file?▼

Yes, use pandas with openpyxl to read, filter, and analyze data across multiple Excel sheets in a single workflow. Extract specific data, perform calculations, and export results while maintaining the original workbook structure.

How do I update an existing Excel spreadsheet while keeping formulas intact?▼

Modify existing spreadsheets using openpyxl to preserve formulas and templates, then recalculate to verify that updates don't introduce errors. This workflow maintains industry-standard formatting and formula integrity across revisions.

What's the best way to recalculate formulas in Excel workbooks?▼

Trigger LibreOffice-based recalculation to refresh all formula values in your workbook, ensuring zero formula errors and accurate results. This integrates with pandas and openpyxl workflows for end-to-end spreadsheet automation.

Do I need to know pandas to automate Excel spreadsheets?▼

No, you can automate spreadsheet creation and editing with openpyxl alone, but pandas integration enables advanced data analysis across multiple sheets. Both are optional depending on whether you need data transformation or formula-driven automation.

Related Skills

Explore More Finance & Accounting Skills→
Qiue-GQiue-G

xlsx

Process and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
georgiymarchenkovgeorgiymarchenkov

Excel Analysis

Analyze Excel spreadsheets with pandas to extract structured insights and generate charts.

Community
Intermediate
psd401psd401
2

xlsx

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

Official
Advanced
claude-office-skillsclaude-office-skills
368

excel-automation

Automate Excel operations with xlwings for live interaction and VBA execution.

Official
Advanced