xlsx

Create and edit Excel workbooks with openpyxl and recalculate formulas via LibreOffice.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/EdisonNi-hku/trace2skill --skill xlsx-edisonni-hku
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/EdisonNi-hku/trace2skill/tree/main/spreadsheet_agent/skills/xlsx
Command: npx skills add https://github.com/EdisonNi-hku/trace2skill --skill xlsx-edisonni-hku

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Spreadsheets often require meticulous formatting preservation and robust formula integrity across complex models; manual edits can introduce errors and break templates, slowing analysis and reporting.

Core Features & Use Cases

  • Openpyxl-based editing to create or modify Excel workbooks while preserving formulas and template styles.
  • Recalculate formulas using recalc.py with LibreOffice integration to ensure outputs reflect data changes.
  • Use Case: Build a financial model from a template, fill in inputs, and automatically recalc all dependent cells across multiple sheets.

Quick Start

Load or create a workbook, apply the standard template, and trigger automatic formula recalculation.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I edit Excel workbooks while preserving template formatting and formulas?

To edit Excel workbooks while preserving template formatting and formulas, use openpyxl-based operations to modify cells without breaking existing styles. This ensures consistent, error-free spreadsheets across multiple sheets.

Can I recalculate Excel formulas automatically after changing input data?

Yes, you can recalculate Excel formulas automatically after changing input data. The tool uses recalc.py with LibreOffice integration to ensure all dependent cells across multiple sheets reflect the updated data changes.

What's the best way to build a financial model from an existing Excel template?

The best way to build a financial model from an Excel template is to load the workbook, fill in inputs, and trigger automatic formula recalculation. This preserves template integrity while ensuring dependent cells update correctly.

Does openpyxl support recalculating formulas across multiple sheets?

Openpyxl handles file operations and formatting preservation, but relies on recalc.py with LibreOffice integration for recalculating formulas across multiple sheets. This combination ensures outputs accurately reflect data changes.

Why do my spreadsheet formulas break when I edit Excel files programmatically?

Spreadsheet formulas break during programmatic edits because manual modifications often disrupt template structures. Using an automated openpyxl-based approach enforces hard rules for template preservation and documentation, preventing these errors.

Do I need LibreOffice to recalculate formulas in xlsx files?

Yes, you need LibreOffice to recalculate formulas in xlsx files. The workflow relies on recalc.py, which uses LibreOffice integration to process and update dependent formula cells accurately across the workbook.