Summary
This is your reference for working with Excel files programmatically, covering both Python libraries (openpyxl for formatting and cell manipulation, pandas for data operations) and JavaScript's xlsx package. You'll reach for this when reading spreadsheets, writing structured data, applying formulas, or converting between Excel and CSV formats. The examples are concise and cover the common patterns you actually need: iterating rows, styling cells, pivoting data, and merging multiple files. It's designed as a quick lookup rather than a tutorial, so you can grab the syntax and get back to work. The pandas examples are especially useful if you're doing any data transformation before writing output.
Install to Claude Code
npx -y skills add bobmatnyc/claude-mpm-skills --skill xlsx --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
