xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill creates, edits, and analyzes Excel workbooks with formulas and formatting, enabling consistent, error-free models and streamlined reporting.

Core Features & Use Cases

  • Formula management: Preserve and recalibrate formulas across sheets and templates.
  • Template fidelity: Copy and apply established formatting and conventions to new workbooks.
  • Data analysis & visualization: Use embedded data to generate insights and charts.
  • Use Case: A finance team updates a 2024 budget workbook, recalculates all linked cells, and exports updated figures while keeping the original template intact.

Quick Start

Run the recalc script on your workbook after making formula changes: python recalc.py my_model.xlsx 30

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel workbook creation with preserved formulas and formatting?

Automating Excel workbook creation preserves formulas and formatting using openpyxl and pandas, ensuring consistent templates and reliable recalculation across XLSX and XLSM files. This prevents manual formatting errors in financial models.

Can I recalculate Excel formulas in XLSX files without opening Excel?

You can recalculate Excel formulas in XLSX files without opening Excel by running the recalc.py script via LibreOffice, ensuring all linked cells update accurately for financial models and reporting tasks.

What is the best way to update a financial model workbook while keeping the original template intact?

The best way to update a financial model while keeping the original template intact is to apply template fidelity features, recalculating linked cells and exporting updated figures without altering established formatting conventions.

Do I need LibreOffice to recalculate formulas in Excel spreadsheets?

You need LibreOffice to execute the recalc.py script for formula recalculation in Excel spreadsheets, while openpyxl and pandas handle data manipulation and template formatting across XLSX, XLSM, CSV, and TSV files.

Does openpyxl support data analysis and visualization across CSV and TSV files?

Openpyxl supports data analysis and visualization across CSV and TSV files by utilizing embedded data to generate insights and charts, working alongside pandas for comprehensive data handling and reporting tasks.

Why does my Excel formula recalculation not working when processing XLSM files?

Excel formula recalculation may not work if LibreOffice is not properly configured to execute recalc.py, which is required to trigger reliable updates across linked cells in XLSX and XLSM workbooks.