xlsx

Create, edit, and format Excel workbooks with formulas across .xlsx, .xlsm, and .csv files.

2|Updated Jan 21, 2026

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

Ready to run

npx skills add https://github.com/roderik/mpe --skill xlsx-roderik

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/roderik/mpe/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/roderik/mpe --skill xlsx-roderik

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

Excel users spend excessive time copying data, applying formulas, and formatting spreadsheets, leading to errors and delays in reporting.

Core Features & Use Cases

Create, edit, and format workbooks with formula support across .xlsx, .xlsm, and .csv files.
Preserve existing templates and styles while applying updates to data and calculations.
Data analysis and visualization: generate summaries, charts, and conditional formatting to support decision making.
Use Case: automatically generate a monthly sales report by populating a template, recalculating formulas, and exporting results to CSV.

Quick Start

Use the xlsx skill to create a new workbook named 'sample.xlsx' with a 3-row table and a simple total formula, then save and open the file to verify outputs.

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 and formula application?▼

Automate Excel workbook creation by using openpyxl to populate templates, apply formulas, and format spreadsheets across .xlsx, .xlsm, and .csv files. This approach eliminates manual data entry errors and accelerates automated reporting workflows.

Can I preserve existing Excel template styles while updating data and formulas?▼

Yes, you can preserve existing Excel template styles while updating data. The workflow applies calculations and data modifications to your templates without overwriting original formatting, ensuring visual consistency across automated report generation.

How does openpyxl handle formula recalculation for zero-error outputs?▼

openpyxl handles formula recalculation by integrating optional recalc tooling and LibreOffice. This mechanism guarantees zero-error outputs by forcing formula updates before saving workbooks, preventing stale cached values in your data analysis.

Does this automated spreadsheet editing approach support .xlsm and .csv files?▼

This automated spreadsheet editing approach fully supports .xlsm and .csv files in addition to standard .xlsx workbooks. You can seamlessly edit, apply formulas, and format across all three formats within your data analytics workflows.

What is the best way to generate Excel data visualizations and summaries for reporting?▼

The best way to generate Excel data visualizations is through programmatic workbook editing that creates summaries, charts, and conditional formatting. This method supports decision making by automatically visualizing data within the generated spreadsheets.

Why do my Excel formulas show stale cached values when using openpyxl?▼

Excel formulas show stale cached values when using openpyxl because it does not natively recalculate formulas on save. The workflow resolves this by utilizing LibreOffice and optional recalc tooling to force calculation and guarantee zero-error outputs.