skills.rest
jyasuu
jyasuuCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas and formatting.

Updated Jul 2, 2024
Search Tags:#automation#formulas#spreadsheet#excel#data-analysis#xlsx
One-click install
npx skills add https://github.com/jyasuu/cheat-sheet --skill xlsx-jyasuu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/jyasuu/cheat-sheet/tree/main/skills/xlsx
Command: npx skills add https://github.com/jyasuu/cheat-sheet --skill xlsx-jyasuu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Claude users often spend excessive time on repetitive spreadsheet tasks, risking human error when creating, editing, and analyzing data across large workbooks.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting, preserving templates and standards.
  • Read, analyze, and visualize data in Excel-compatible formats (.xlsx, .xlsm, .csv, .tsv).
  • Modify existing spreadsheets while preserving formulas and structure, and recalculate results when inputs change.

Quick Start

Create a new workbook using the monthly sales template with formulas and formatting ready for data entry.

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?▼

You can automate spreadsheet creation by generating new workbooks with formulas and formatting using openpyxl. This skill structures templates and applies formulas directly, producing ready-to-enter .xlsx files without manual setup.

Can I modify existing .xlsx files while preserving formulas?▼

Yes, you can modify existing .xlsx files while preserving their formulas and structure. The skill edits spreadsheet data without overwriting existing formula logic, ensuring templates remain intact across data updates.

How do I recalculate Excel formulas after updating spreadsheet data?▼

Recalculate spreadsheet formulas after data updates by using recalc.py with LibreOffice. This ensures deterministic results and correct formula recalculation across modified .xlsx and .xlsm workbooks.

Does this spreadsheet automation approach support .csv and .tsv files?▼

Yes, this spreadsheet automation approach supports .csv and .tsv files alongside .xlsx and .xlsm formats. It reads, analyzes, and modifies tabular data across all these Excel-compatible file types.

What is the best way to analyze and visualize data in Excel spreadsheets automatically?▼

The best way to analyze and visualize spreadsheet data automatically is by using openpyxl for Excel operations. This skill reads data from .xlsx and .xlsm files to extract insights and generate data visualizations.

Related Skills

Explore More Data & Analytics Skills→
ChenYCLChenYCL

xlsx

Create, read, edit, and analyze Excel spreadsheet files with openpyxl and pandas.

Community
Intermediate
Ab0umarAb0umar

Spreadsheets

Create and modify multi-sheet .xlsx workbooks with formulas and charts.

Community
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced