skills.rest
shuyu-labs
shuyu-labsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

xlsx

Create and edit Excel-compatible workbooks with formulas and charts.

288|42|Updated Jan 14, 2026
Search Tags:#openpyxl#formulas#spreadsheet#data-analysis#xlsx#CSV
One-click install
npx skills add https://github.com/shuyu-labs/WebCode --skill xlsx-shuyu-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/shuyu-labs/WebCode/tree/main/skills/claude/xlsx
Command: npx skills add https://github.com/shuyu-labs/WebCode --skill xlsx-shuyu-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates spreadsheet creation, editing, formatting, data import, analysis, and visualization across Excel-compatible files, reducing manual work and errors.

Core Features & Use Cases

  • Spreadsheet creation: generate new workbooks with formulas, styles, and templates.
  • Data reading and analysis: import and inspect data from CSV/TSV and other sources, then summarize results.
  • Formula-preserving edits: modify existing templates while keeping formulas intact.
  • Visualization & exports: create basic charts and export results to CSV, Excel, or other formats.
  • Use Case: A financial analyst needs a monthly budget model; generate the workbook, populate it with data, recalc formulas, and produce a summary sheet.

Quick Start

Ask Claude to create a new budget workbook with a simple P&L template, populate it with sample data, and ensure all formulas recalculate when data changes.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit an Excel template while preserving existing formulas?▼

You can edit Excel templates while preserving formulas by using a spreadsheet automation workflow that relies on openpyxl for file manipulation. This approach modifies cell values without overwriting formula structures, then applies a LibreOffice-based recalculation process to update computed results.

Can I import data from a CSV file into an Excel workbook and generate visual summaries?▼

Yes, importing CSV or TSV data into an Excel-compatible workbook and generating visual summaries is fully supported. The process reads raw tabular data, populates the spreadsheet cells, and creates basic charts to visualize the imported information for analysis.

What is the best way to automate building a financial model in Excel?▼

Automating financial model creation in Excel is best achieved by programmatically generating a new workbook with formulas, styles, and templates. This method populates the model with data and applies a recalculation workflow to ensure all financial formulas compute correctly.

Does openpyxl support recalculating formulas after modifying spreadsheet data?▼

While openpyxl handles file manipulation, it does not automatically recalculate formulas upon data modification. The spreadsheet automation addresses this by employing a LibreOffice-based recalculation workflow via recalc.py, ensuring formula values update correctly after file changes.

How do I create a new Excel workbook with custom styles and formulas from scratch?▼

Creating a new Excel workbook with custom styles and formulas involves generating a new file using openpyxl. The spreadsheet automation applies specified cell styles, injects the necessary formulas, and triggers a recalculation workflow to compute the initial formula results automatically.

Related Skills

Explore More Data & Analytics Skills→
cookeyholdercookeyholder

xlsx

Open, edit, clean, and convert XLSX, XLSM, CSV, and TSV spreadsheets.

Community
Intermediate
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

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

Official
Intermediate
kevinlinkevinlin
14

data-create-viz

Create publication-quality charts from CSV, Excel, or DataFrame data using Python.

Community
Intermediate