xlsx

Create and edit Excel-compatible spreadsheets with formulas and formatting.

Updated Jan 8, 2026
One-click install
npx skills add https://github.com/quany/skills --skill xlsx-quany
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/quany/skills/tree/main/xlsx
Command: npx skills add https://github.com/quany/skills --skill xlsx-quany

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the end-to-end handling of spreadsheets, eliminating manual, repetitive steps in creating, editing, and analyzing Excel-compatible files.

Core Features & Use Cases

  • Automated creation and formatting of new spreadsheets with formulas.
  • Preservation of existing formulas and templates during updates.
  • Data analysis and visualization in spreadsheet formats (xlsx/xlsm/csv/tsv).
  • Use Case: Generate monthly budgets, reconcile data, and regenerate reports with updated inputs.

Quick Start

Use the xlsx skill to generate a new budget workbook with formulas across multiple sheets and save as 'budget.xlsx'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation while preserving existing formulas?

You can automate spreadsheet creation by using workflows that generate new Excel-compatible files while preserving existing formulas and templates during updates. This approach eliminates manual steps in updating reports and budgets.

Can I recalculate formulas in xlsx files without opening Excel?

Yes, you can recalculate formulas in xlsx files without Excel by utilizing LibreOffice and OpenPyXL-based workflows. This process validates and updates formula results programmatically for automated reporting.

What is the best way to automate data cleaning across multiple spreadsheet formats?

The best way to automate data cleaning across spreadsheet formats is using a tool that processes xlsx, xlsm, csv, and tsv files. It applies requirements to manage formatting and validate data efficiently.

Does this spreadsheet automation approach support budgeting and monthly report generation?

Yes, this spreadsheet automation approach supports budgeting and monthly report generation. It handles end-to-end business workflows, allowing you to generate budget workbooks with formulas across multiple sheets.

Why do my spreadsheet formulas break when updating Excel files programmatically?

Spreadsheet formulas often break during programmatic updates if the workflow does not explicitly preserve them. Utilizing OpenPyXL-based workflows ensures existing formulas and templates remain intact during data reconciliation.