xlsx

Create, edit, and analyze .xlsx, .xlsm, and .csv spreadsheets with formulas and formatting.

Updated Jun 17, 2025
One-click install
npx skills add https://github.com/jax2730/workcode --skill xlsx-jax2730
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/jax2730/workcode/tree/main/LLM%26Dialog/.claude/skills/xlsx
Command: npx skills add https://github.com/jax2730/workcode --skill xlsx-jax2730

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 data efficiently, handling complex formulas, formatting, and data manipulation tasks.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new spreadsheets or modify existing ones, including adding data, formulas, and formatting.
  • Data Analysis & Visualization: Analyze data within spreadsheets using powerful tools and create visualizations.
  • Formula Management: Ensure formula accuracy, recalculate values, and prevent common formula errors.
  • Use Case: A financial analyst can use this Skill to build a complex financial model, inputting assumptions, defining formulas, and ensuring all calculations are accurate and properly formatted according to industry standards.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and populate it with the provided sales data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create a spreadsheet with formulas and formatting from raw data?

You can create a spreadsheet by generating a new .xlsx file, defining columns, populating it with your data, and applying formulas and formatting. This handles both structure and styling directly.

Can I edit an existing .xlsx file without breaking its current formulas?

Yes, you can modify existing .xlsx spreadsheets while preserving formulas. The Skill manages formula accuracy and structural integrity, ensuring your original calculations remain intact when you add or change data.

How do I recalculate spreadsheet formulas after modifying the data?

Recalculating spreadsheet formulas after data modification is handled using LibreOffice via a recalc.py script. This integration ensures all formula values are accurately updated and common formula errors are prevented.

Does pandas support spreadsheet data analysis and visualization for .xlsm files?

Pandas supports data analysis and visualization for .xlsm files, alongside .xlsx and .csv formats. It handles the underlying data manipulation, while openpyxl manages the specific formula and formatting requirements.

What is the best way to build a financial model in Excel using AI?

The best way to build a financial model in Excel is to input your assumptions, define calculation formulas, and apply industry-standard formatting. This approach ensures all calculations are accurate and properly formatted.