xlsx

Name: xlsx
Availability: InStock
Author: cissou34730

Create and edit Excel workbooks with openpyxl while preserving formulas.

Updated Nov 20, 2025

Search Tags:#automation #formulas #spreadsheet #excel #data-analysis #xlsx #recalc

Ready to run

npx skills add https://github.com/Cissou34730/Azure-Architect-Assistant --skill xlsx-cissou34730

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Cissou34730/Azure-Architect-Assistant/tree/main/.github/skills/xlsx
Command: npx skills add https://github.com/Cissou34730/Azure-Architect-Assistant --skill xlsx-cissou34730

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the tedious tasks of creating, editing, and analyzing Excel workbooks, ensuring formulas stay intact and templates are preserved across updates.

Core Features & Use Cases

Workbook creation and formatting: generate new spreadsheets with initial data, formulas, and styling to match templates.
Formula preservation and recalculation: maintain formulas during edits and enable reproducible recalculation using LibreOffice-based tooling.
Data analysis and reporting: perform data cleansing, aggregation, and basic visualization inside Excel, suitable for dashboards and reporting pipelines.

Quick Start

Use this skill to create a new workbook, e.g., a 12-month sales forecast with built-in formulas; or to modify an existing workbook while preserving formulas.

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 and analysis while preserving formulas?▼

Automate Excel workbook creation and analysis using Python and openpyxl to build models, validate formulas, and preserve templates while editing existing .xlsx or .xlsm files.

What is the best way to recalculate Excel formulas after modifying a spreadsheet programmatically?▼

Reproducible spreadsheet recalculation is handled using a LibreOffice-based recalc tool, ensuring formula accuracy and updated calculated values after programmatic edits are applied.

Can I use Python to clean and format data inside an Excel workbook for reporting?▼

Python can perform data cleansing, aggregation, and formatting inside Excel workbooks, generating structured data suitable for dashboards and reporting pipelines.

Does this approach to spreadsheet automation support .xlsm files with existing templates?▼

Excel automation supports .xlsx and .xlsm formats, ensuring existing templates are preserved across updates while maintaining formula accuracy during edits.

How do I build a sales forecast model in Excel with built-in formulas automatically?▼

Generate new spreadsheets with initial data, formulas, and styling to match templates, creating models like a 12-month sales forecast with built-in formulas automatically.

What are the limitations of using openpyxl for Excel spreadsheet recalculation?▼

openpyxl handles workbook creation and formula preservation but relies on a LibreOffice-based recalc tool for reproducible recalculation, as Python alone cannot natively evaluate Excel formulas.