xlsx

Create, edit, and analyze spreadsheet files with formulas and pandas-based workflows.

Updated Feb 2, 2026
One-click install
npx skills add https://github.com/sandriaas/_dotfiles --skill xlsx-sandriaas
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/sandriaas/_dotfiles/tree/main/local/.claude/skills/xlsx
Command: npx skills add https://github.com/sandriaas/_dotfiles --skill xlsx-sandriaas

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 complex spreadsheet files (.xlsx, .xlsm, .csv, .tsv) with advanced formula support, formatting, and data visualization capabilities.

Core Features & Use Cases

  • Formula Creation & Management: Generate and manage intricate Excel formulas, ensuring accuracy and preventing errors.
  • Data Analysis & Visualization: Analyze data using pandas and create visualizations within spreadsheets.
  • Formatting & Styling: Apply industry-standard color coding and number formatting.
  • Use Case: Automatically generate a financial projection model with dynamic formulas, apply standard color-coding for assumptions and calculations, and ensure all formulas are error-free before delivery.

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 sample data.

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 error checking?

To create an Excel financial model with dynamic formulas, you need a tool that generates formulas, enforces calculation integrity through recalculation, and applies standard color-coding for assumptions to deliver error-free spreadsheet files.

Can pandas and openpyxl be used together for spreadsheet data analysis and formatting?

Pandas and openpyxl can be used together for spreadsheet data analysis and formatting by leveraging pandas for data manipulation and openpyxl for applying industry-standard number formatting and implementing complex Excel formulas.

What spreadsheet file formats are supported for data analysis and visualization?

Supported spreadsheet file formats for data analysis and visualization include .xlsx, .xlsm, .csv, and .tsv, allowing you to edit, analyze, and visualize tabular data across various standard spreadsheet structures.

How do I automate generating a sales report in xlsx with standard formatting?

Automating a sales report in xlsx involves creating a spreadsheet file, populating it with data columns like Date and Revenue, and applying standard formatting and visualization through programmatic spreadsheet generation and formula management.

Does LibreOffice work with xlsx files for formula recalculation and error checking?

LibreOffice works with xlsx files by ensuring formula integrity through automated recalculation and error checking, validating that complex spreadsheet formulas calculate correctly before final delivery.

What is the best way to apply financial modeling standards to a spreadsheet?

The best way to apply financial modeling standards to a spreadsheet is by using tools that enforce formula accuracy, apply industry-standard color coding for assumptions, and validate calculations through recalculation and error checking.