xlsx

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

Updated Mar 13, 2026

Search Tags:#pandas #openpyxl #formulas #spreadsheet #excel #xlsx

Ready to run

npx skills add https://github.com/colinmxs/double-hexagon --skill xlsx-colinmxs

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/colinmxs/double-hexagon/tree/main/.kiro/skills/document-skills/xlsx
Command: npx skills add https://github.com/colinmxs/double-hexagon --skill xlsx-colinmxs

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheets while preserving formulas and formatting across updates, reducing manual routine work.

Core Features & Use Cases

Create new workbooks with formulas and formatting
Read, analyze, and transform data across sheets
Modify existing workbooks while preserving formulas and structure
Recalculate formulas and validate results to ensure accuracy

Quick Start

Create a new workbook that computes total sales from a sample data table and formats results automatically.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I edit an existing Excel file while preserving formulas and formatting?▼

To edit an Excel file while preserving formulas and formatting, this Skill modifies existing workbooks using openpyxl and pandas, ensuring structural integrity and formula retention across updates.

How do I create a new spreadsheet with formulas automatically?▼

You can create a new spreadsheet with formulas automatically by defining your data and calculations. This Skill generates new workbooks with applied formulas and formatting, automating the layout and computation setup for routine tasks like sales reporting.

Can I use pandas to read and analyze data across multiple Excel sheets?▼

Yes, you can use pandas to read and analyze data across multiple Excel sheets. This Skill reads, analyzes, and transforms data across sheets, allowing you to extract and process workbook information efficiently.

How do I recalculate and validate spreadsheet formulas after modifying an xlsx file?▼

To recalculate and validate spreadsheet formulas after modifying an xlsx file, this Skill provides a LibreOffice-based recalculation workflow via recalc.py to validate results. This ensures your updated formulas compute accurately before finalizing the workbook.

Does openpyxl support modifying existing workbooks without losing structure?▼

Yes, openpyxl supports modifying existing workbooks without losing structure. This Skill leverages openpyxl and pandas for workbook manipulation, specifically targeting modifications that preserve formulas and formatting while transforming your data.