xlsx

Create, edit, and analyze Excel workbooks with formulas using Python openpyxl and LibreOffice recalculation.

1|Updated Jan 26, 2026

Search Tags:#automation #visualization #openpyxl #formulas #excel #data-analysis #xlsx

Ready to run

npx skills add https://github.com/Victory-Hugo/S2-Agent-Skill --skill xlsx-victory-hugo

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Victory-Hugo/S2-Agent-Skill/tree/main/skills/xlsx
Command: npx skills add https://github.com/Victory-Hugo/S2-Agent-Skill --skill xlsx-victory-hugo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a streamlined solution for creating, editing, and analyzing Excel workbooks, reducing manual formatting, formula maintenance, and data presentation workload.

Core Features & Use Cases

Workbook creation and templating: programmatically generate new spreadsheets with predefined headers, styles, and formulas.
Formula management and recalculation: preserve, update, and recalibrate formulas across edits using openpyxl and a LibreOffice-based recalculation workflow.
Data analysis and visualization: perform data aggregation, generate summaries, and embed charts within Excel workbooks.

Quick Start

Ensure Python environment and LibreOffice are installed.
Run a simple script to create a workbook and add a sheet with a SUM formula, e.g., =SUM(A1:A10).
Recalculate all formulas with the included recalc.py tool to verify correctness.

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 formula management?▼

Automate Excel workbook creation by programmatically generating spreadsheets with predefined headers, styles, and formulas. You can preserve and update formulas across edits using openpyxl and a LibreOffice-based recalculation workflow to verify correctness.

Can I use openpyxl to recalculate formulas in an existing Excel workbook?▼

openpyxl itself does not recalculate formulas, but you can use a LibreOffice-based recalc tool to recalculate all formulas in an Excel workbook. This workflow ensures formula correctness after programmatic edits and data manipulation.

What's the best way to embed charts and data visualizations in Excel workbooks?▼

The best way to embed data visualizations in Excel workbooks is to use openpyxl for programmatic chart generation. This supports data-heavy workflows by allowing you to perform data aggregation and embed charts directly within the spreadsheets.

Do I need LibreOffice to edit Excel workbooks with Python?▼

You need LibreOffice specifically for formula recalculation when editing Excel workbooks with Python. While openpyxl handles data manipulation and formatting, LibreOffice is required to recalculate formulas and verify their correctness across multiple sheets.

How do I preserve templates and document hardcoded values when editing Excel files?▼

When editing Excel files, you can preserve templates and document hardcoded values using openpyxl. This approach maintains predefined styles and formulas while validating formulas during data manipulation across multiple sheets.

Why does openpyxl not calculate Excel formulas automatically?▼

openpyxl does not calculate Excel formulas automatically because it is a file manipulation library rather than a calculation engine. You must use a LibreOffice-based recalculation tool to process formulas and validate their computed results.