skills.rest
Jimmy1987s
Jimmy1987sCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel spreadsheets with formulas and formatting using pandas and openpyxl.

Updated Aug 27, 2026
Search Tags:#financial modeling#data analysis#formulas#spreadsheet#excel#xlsx#csv
One-click install
npx skills add https://github.com/Jimmy1987s/EC-Claude-Skills --skill xlsx-jimmy1987s
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Jimmy1987s/EC-Claude-Skills/tree/main/skills/document-xlsx
Command: npx skills add https://github.com/Jimmy1987s/EC-Claude-Skills --skill xlsx-jimmy1987s

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet files (.xlsx, .xlsm, .csv, .tsv) programmatically, handling everything from complex formulas and formatting to data analysis and visualization.

Core Features & Use Cases

  • Comprehensive Spreadsheet Management: Build new spreadsheets with intricate formulas and formatting, or modify existing ones while preserving their integrity.
  • Data Analysis & Visualization: Extract, analyze, and visualize data directly within spreadsheets.
  • Formula Recalculation & Error Handling: Ensures all formulas are correctly calculated and identifies/fixes common spreadsheet errors.
  • Use Case: Automatically generate a financial forecast model in Excel, including all necessary formulas, formatting, and data links, based on provided assumptions.

Quick Start

Use the xlsx skill to create a new Excel file named 'financial_report.xlsx' with sales data and a sum formula in cell B10.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel file with formulas programmatically?▼

Yes, you can modify existing Excel files while preserving their integrity. The Skill uses openpyxl to edit .xlsx and .xlsm files, allowing you to update data, adjust formatting, and manage formulas without corrupting the original spreadsheet structure.

What is the best way to recalculate Excel formulas and fix spreadsheet errors?▼

This Skill supports comprehensive data analysis and visualization directly within spreadsheets. It uses pandas to extract and analyze your data, allowing you to visualize trends and generate reports inside your .xlsx, .csv, or .tsv files.

Does this spreadsheet tool support CSV and TSV file formats?▼

Yes, this spreadsheet tool supports CSV and TSV file formats alongside .xlsx and .xlsm. It uses Python libraries like pandas and openpyxl to provide comprehensive creation, editing, and analysis capabilities across all these supported formats.

Can I automate financial modeling and generate reports in Excel?▼

Yes, you can automate financial modeling and generate reports in Excel. The Skill creates financial forecast models automatically, including all necessary formulas, formatting, and data links based on the financial assumptions you provide.

Related Skills

Explore More Finance & Accounting Skills→
HerxinsasaHerxinsasa
1

xlsx

Create, edit, analyze, and convert Excel and CSV/TSV spreadsheet files.

Community
Advanced
koralliskorallis
90

document-processing-xlsx

Create, parse, and manipulate Excel spreadsheets using xlsx, exceljs, or SheetJS.

Community
Intermediate
treasure-datatreasure-data
21

trino-cli

Execute SQL queries against Treasure Data using the Trino CLI.

Official
Intermediate
jimmc414jimmc414
557

xlsx

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

Community
Advanced