One-click install
npx skills add https://github.com/loanntc/Paave --skill xlsx-loanntc
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/loanntc/Paave/tree/main/skills/xlsx
Command: npx skills add https://github.com/loanntc/Paave --skill xlsx-loanntc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, pandas, validators, lxml, defusedxml, gcc, soffice, timeout, gtimeout, and includes scripts (resource) components.

What problem does it solve?

This Skill removes the pain of working with spreadsheets by enabling robust creation, editing, conversion, and formula-safe fixes for tabular files.

Core Features & Use Cases

  • Create and edit spreadsheets end-to-end: build new workbooks from requirements or modify existing .xlsx/.xlsm/.csv/.tsv tabular files.
  • Clean and restructure messy tabular data: fix malformed rows, misplaced headers, and junk data into a properly structured spreadsheet.
  • Prevent spreadsheet breakage: enforce zero Excel formula errors and validate output by recalculating formulas using LibreOffice.
  • Handle complex models with specialist workflow: uses a lead-and-specialist approach for multi-sheet financial models and dashboards.
  • Use-case: convert an exported CSV with messy headers into a clean workbook, compute required totals with Excel formulas, and deliver a recalculated, error-free .xlsx.

Quick Start

Request the xlsx skill to convert the tabular file at the given path into a corrected and formatted Excel workbook with all formulas recalculated and no Excel error values.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix Excel formula errors like #REF! and #DIV/0! in my workbook?

To fix Excel formula errors like #REF! and #DIV/0!, this Skill repairs formulas and recalculates the workbook using LibreOffice, enforcing zero Excel formula errors in the final spreadsheet deliverable.

What is the best way to convert a messy CSV file into a clean Excel workbook?

The best way to convert a messy CSV into a clean Excel workbook is using this Skill to restructure misplaced headers, fix malformed rows, and compute required totals with Excel formulas rather than hardcoded Python values.

Can I build multi-sheet financial models using Excel formulas instead of Python hardcoding?

Yes, you can build multi-sheet financial models because this Skill uses a specialist workflow to handle complex workbooks and must use Excel formulas, not Python hardcoding, to produce the recalculated spreadsheet deliverable.

Does this spreadsheet cleaning tool support .xlsm and .tsv tabular data formats?

This spreadsheet cleaning tool supports .xlsx, .xlsm, .csv, and .tsv tabular data formats, allowing you to read, edit, restructure, and convert these files into properly formatted, error-free spreadsheet outputs.

Why does my spreadsheet output show #VALUE! errors after data conversion?

Spreadsheet outputs show #VALUE! errors after data conversion due to broken formulas or incompatible data types; this Skill prevents spreadsheet breakage by validating outputs and enforcing zero Excel formula errors.

How do I repair and restructure tabular data with misplaced headers and junk data?

To repair and restructure tabular data with misplaced headers and junk data, this Skill cleans the malformed rows and restructures the messy data into a properly formatted, recalculated, and error-free spreadsheet.