xlsx

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

Updated Jan 16, 2026
One-click install
npx skills add https://github.com/Zaibunis/spec-driven-hackathons --skill xlsx-zaibunis
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Zaibunis/spec-driven-hackathons/tree/main/phase-5/.claude/skills/xlsx
Command: npx skills add https://github.com/Zaibunis/spec-driven-hackathons --skill xlsx-zaibunis

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill empowers users to create, edit, and analyze spreadsheet data, ensuring accuracy and dynamic calculations through robust formula management and data handling.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files or modify existing ones with data, formulas, and formatting.
  • Formula Management: Ensures all formulas are correctly implemented, error-free, and recalculable.
  • Data Analysis: Leverages pandas for in-depth data analysis and visualization directly from spreadsheet data.
  • Use Case: Automatically generate a financial projection spreadsheet with industry-standard formatting and complex formulas, ensuring all calculations are accurate and verifiable.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue', and add a formula to calculate the total revenue in cell D2.

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 financial model with dynamic formulas and standard formatting?

To create an Excel financial model, you can generate new .xlsx files with implemented formulas, specific color-coding, and number formatting standards. The model ensures dynamic calculations and accuracy through automated formula recalculation.

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

Yes, you can use pandas for data analysis directly on existing Excel files. This approach enables in-depth data manipulation and visualization by leveraging pandas to process the spreadsheet data extracted from your .xlsx or .csv files.

Does LibreOffice recalculate spreadsheet formulas to maintain formula integrity?

Yes, LibreOffice recalculates spreadsheet formulas to maintain formula integrity. By processing the .xlsx files through LibreOffice, the system ensures that all implemented formulas are error-free, correctly evaluated, and dynamically updated.

What is the best way to edit and add formulas to an existing .xlsx file programmatically?

The best way to edit and add formulas to an existing .xlsx file is by using openpyxl to modify the spreadsheet structure. This allows you to insert formulas, apply formatting changes, and update data directly within the workbook.

Can I handle multiple spreadsheet formats like .csv and .tsv with the same tool?

Yes, you can handle multiple spreadsheet formats like .csv and .tsv with the same tool. The system supports comprehensive manipulation across .xlsx, .xlsm, .csv, and .tsv files for creation, editing, and analysis tasks.

Why do my spreadsheet formulas show errors after automated data analysis?

Spreadsheet formulas show errors after automated data analysis if formula integrity is not verified. Running LibreOffice recalculation on the modified .xlsx file ensures all formulas are correctly implemented, error-free, and recalculated accurately.