xlsx

Create, edit, and analyze spreadsheet files with formulas and formatting.

Updated Feb 2, 2026

Search Tags:#Excel #pandas #openpyxl #formulas #spreadsheet #data-analysis #xlsx

Ready to run

npx skills add https://github.com/vuminhieu/spexor-client --skill xlsx-vuminhieu

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/vuminhieu/spexor-client/tree/main/.agent/skills/skills/xlsx
Command: npx skills add https://github.com/vuminhieu/spexor-client --skill xlsx-vuminhieu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill reduces the manual burden of creating, formatting, and analyzing spreadsheets across common formats (.xlsx, .xlsm, .csv, .tsv), while preserving formulas and ensuring reliable recalculation.

Core Features & Use Cases

Workbook creation: Generate new workbooks with formulas and structured formatting from data sources.
Data reading & analysis: Import data, compute metrics, and visualize results within sheets.
Update existing sheets while preserving formulas: Modify templates and models without breaking formulas.
Use Case: Prepare monthly financial models by importing data, applying formulas, and producing updated reports.

Quick Start

Use the xlsx skill to create a new workbook from a sample dataset and apply a simple formula across a range.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I update an existing Excel workbook while preserving formulas?▼

To update an existing Excel workbook while preserving formulas, use the xlsx Skill to modify templates and models. It edits existing sheets and relies on a LibreOffice-based recalc workflow to recalculate formulas and ensure data integrity without breaking existing structures.

Can I use pandas and openpyxl to generate new spreadsheets with formatting?▼

Yes, you can generate new spreadsheets with formatting. The xlsx Skill uses Python tooling like pandas and openpyxl to automate workbook creation, applying structured formatting and formulas directly from your data sources.

Does this approach support reading and analyzing CSV and TSV files?▼

Reading and analyzing CSV and TSV files is fully supported. The Skill imports data from .csv and .tsv formats, computes metrics, and visualizes results within sheets, alongside handling standard .xlsx and .xlsm files.

What is the best way to automate monthly financial model preparation in Excel?▼

The best way to automate monthly financial model preparation is using the xlsx Skill to import data, apply formulas, and produce updated reports. It reduces manual burden by replacing repetitive workbook tasks with automated generation and recalculation.

Why does spreadsheet recalculation fail when updating models, and how is it fixed?▼

Spreadsheet recalculation fails when manual updates break formula references. The xlsx Skill fixes this by using a LibreOffice-based recalc workflow to recalculate formulas automatically, ensuring data integrity and preventing broken models.