skills.rest
fairwic
fairwicCOMMUNITY
Explore all skills by this author →
𝕏@onionsfangGitHub

xlsx

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

25|12|Updated Jun 4, 2024
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#recalculation
One-click install
npx skills add https://github.com/fairwic/rust_quant --skill xlsx-fairwic
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/fairwic/rust_quant/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/fairwic/rust_quant --skill xlsx-fairwic

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring data integrity and dynamic calculations.

Core Features & Use Cases

  • Dynamic Formula Management: Create and update spreadsheets with complex formulas that recalculate automatically.
  • Data Analysis & Visualization: Leverage pandas for in-depth data analysis and openpyxl for precise formatting and structure.
  • Use Case: Generate a financial projection model in Excel, complete with formulas for revenue growth, cost calculations, and profit margins, ensuring all figures update dynamically based on input assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'financial_report.xlsx' with columns for 'Date', 'Revenue', and 'Expenses', and add a formula in the 'Profit' column that subtracts 'Expenses' from 'Revenue'.

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 spreadsheet with formulas that recalculate automatically?▼

Spreadsheet formula recalculation is handled by a provided Python script that forces formula updates, ensuring dynamic calculations like profit margins reflect current input assumptions across .xlsx and .xlsm files.

Can I use pandas for data analysis on existing Excel files?▼

Pandas data analysis is supported for Excel files, enabling in-depth data reporting and structured data manipulation directly within .xlsx, .csv, and .tsv spreadsheet environments.

Does this approach support financial modeling in .xlsm files?▼

Financial modeling in .xlsm files is supported, enabling dynamic projection models with formulas for revenue growth and cost calculations alongside precise formatting via openpyxl.

What's the best way to build a financial projection model in Excel?▼

Building a financial projection model in Excel is best handled by using openpyxl for precise formatting and pandas for data analysis, ensuring cost calculations and profit margins update dynamically via mandatory formula recalculation.

How do I format spreadsheet data and handle multiple file types like CSV and TSV?▼

Spreadsheet data formatting across multiple file types is managed using openpyxl for precise structure, supporting creation and editing of .xlsx, .xlsm, .csv, and .tsv files for comprehensive data reporting.

Related Skills

Explore More Finance & Accounting Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
claude-office-skillsclaude-office-skills
368

data-analysis

Analyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.

Official
Intermediate
Renzo-TognellaRenzo-Tognella

spreadsheet

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

Community
Intermediate
liutao96liutao96

xlsx 电子表格处理

Automate Excel data handling and formula-driven models with openpyxl, pandas, and LibreOffice recalc.

Community
Intermediate