xlsx

Create and edit .xlsx spreadsheets with formulas, formatting, and LibreOffice recalculation.

2|Updated Nov 15, 2025
One-click install
npx skills add https://github.com/dakesan/hiro-favorite-skills --skill xlsx-dakesan
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dakesan/hiro-favorite-skills/tree/main/skills/xlsx
Command: npx skills add https://github.com/dakesan/hiro-favorite-skills --skill xlsx-dakesan

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the manual drudgery and error-prone nature of spreadsheet management. It automates the creation, editing, and analysis of Excel files, ensuring formula integrity, consistent formatting, and accurate recalculations, freeing you from tedious data entry and validation.

Core Features & Use Cases

  • Formula-Driven Spreadsheets: Creates and modifies .xlsx files with dynamic formulas, not hardcoded values, ensuring models remain flexible.
  • Data Analysis & Formatting: Integrates pandas for powerful data manipulation and openpyxl for precise formatting and styling.
  • Automated Recalculation & Error Checking: Uses LibreOffice to recalculate formulas and identifies common Excel errors like #REF! or #DIV/0!.
  • Use Case: You need to generate a monthly financial report with complex interlinked formulas. Use this Skill to create the spreadsheet, populate it with data, ensure all formulas are correct, and automatically recalculate values, delivering a perfect report every time.

Quick Start

Use the xlsx skill to create a new spreadsheet named monthly_report.xlsx with two columns: 'Product' and 'Sales', and add some sample data.

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 with formulas instead of static values?

Automate spreadsheet creation by using openpyxl to build .xlsx files with dynamic formulas, then validate with LibreOffice recalculation to ensure formula integrity and eliminate errors like #REF! or #DIV/0! before delivery.

Can I modify existing Excel files while preserving formulas and formatting?

Yes. This Skill edits existing .xlsx, .xlsm, .csv, and .tsv files while maintaining all formulas, color conventions, and formatting intact, then recalculates to verify no errors were introduced.

What's the best way to analyze and format data across multiple spreadsheets?

Integrate pandas for powerful data manipulation and openpyxl for precise styling and cell-level formatting, then validate results through LibreOffice-backed recalculation to ensure accuracy across all linked files.

How do I generate financial reports with complex interlinked formulas automatically?

Create spreadsheets with interdependent formulas using openpyxl, populate with data via pandas, then use LibreOffice recalculation to verify all formula chains work correctly and deliver error-free reports.

Can I use this for data analysis tasks beyond report generation?

Yes. Perform data analysis and visualization directly within spreadsheets by reading and transforming .xlsx, .csv, and .tsv files with pandas, applying formatting with openpyxl, and recalculating formulas to validate results.

Do I need to manually recalculate formulas after editing spreadsheets?

No. LibreOffice automatically recalculates all formulas after edits and identifies errors, eliminating manual validation and ensuring every modified spreadsheet is mathematically sound before use.