xlsx

Name: xlsx
Availability: InStock
Author: moritalous

Creates, edits, and analyzes Excel-compatible spreadsheets using openpyxl and optional pandas.

11|Updated Dec 27, 2025

Search Tags:#automation #pandas #openpyxl #formulas #spreadsheet #data-analysis #xlsx

Ready to run

npx skills add https://github.com/moritalous/claude-code-on-agentcore --skill xlsx-moritalous

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/moritalous/claude-code-on-agentcore/tree/main/backend/assets/claude-agent/app/.claude/skills/xlsx
Command: npx skills add https://github.com/moritalous/claude-code-on-agentcore --skill xlsx-moritalous

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the end-to-end creation, editing, and analysis of spreadsheets, reducing manual workloads, errors, and repetitive formatting tasks.

Core Features & Use Cases

Create new workbooks with formulas, formatting, and conditional styling across multiple sheets.
Read, summarize, and analyze data from XLSX, CSV, and TSV files with reproducible results.
Update existing workbooks while preserving formulas and structure, enabling safe template reuse and batch updates.
Recalculate formulas programmatically to verify outcomes after data changes.

Quick Start

Create a new workbook named sales.xlsx with a sheet "Q1" containing columns Date, Revenue, and Growth, add a formula to compute Growth, format headers, and save as sales.xlsx.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate spreadsheet creation and add formulas across multiple sheets?▼

Automate spreadsheet creation by generating new workbooks with formulas, formatting, and conditional styling across multiple sheets. It programmatically builds files, reducing manual data entry and formatting errors.

Can I update an existing xlsx file while preserving its formulas and structure?▼

Yes, you can update existing xlsx files while preserving their formulas and structure. This Skill enables safe template reuse and batch updates by modifying data without destroying the underlying formula logic or workbook layout.

How do I analyze data from CSV and TSV files using Python for spreadsheet automation?▼

Analyze data from CSV and TSV files using Python libraries like pandas and openpyxl. This Skill reads, summarizes, and extracts insights from your data with reproducible results, requiring no graphical interface to execute.

Do I need a Python environment to recalculate spreadsheet formulas programmatically?▼

Yes, you need a Python environment to recalculate spreadsheet formulas programmatically. This Skill relies on Python libraries such as openpyxl to verify outcomes after data changes and execute automated workbook updates without a graphical interface.

What is the best way to batch update Excel templates without losing conditional formatting?▼

The best way to batch update Excel templates without losing conditional formatting is to use an automation Skill that modifies existing workbooks while preserving formulas and structure. This allows safe, repetitive template updates without manual editing.