xlsx

Create and edit Excel workbooks with formulas using openpyxl.

869|203|Updated May 7, 2026

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

Ready to run

npx skills add https://github.com/freestylefly/wesight --skill xlsx-freestylefly

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/freestylefly/wesight/tree/main/SKILLs/xlsx
Command: npx skills add https://github.com/freestylefly/wesight --skill xlsx-freestylefly

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates the creation, editing, and analysis of Excel workbooks, preserving formulas and formatting while enabling deterministic recalculation.

Core Features & Use Cases

Workbook creation: Create new workbooks with formulas and formatting.
Data analysis: Read, analyze, and transform spreadsheet data.
Recalculation: Recalculate formulas automatically to ensure up-to-date results.

Quick Start

Create a new workbook, fill data, define formulas with openpyxl, and run recalc.py to refresh calculations.

Frequently Asked Questions about xlsx

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

FAQPage Schema

How do I automate Excel workbooks while preserving formulas and formatting?▼

Automate Excel workbooks using Python and openpyxl to create, edit, and analyze spreadsheets while preserving formulas and formatting, then run a LibreOffice-based recalc tool to refresh calculations.

Can I programmatically generate and recalculate .xlsx files with openpyxl?▼

Yes, you can programmatically generate .xlsx files with openpyxl by filling data and defining formulas, then execute a recalc script to ensure deterministic recalculation and up-to-date results.

Does this spreadsheet automation approach support .xlsm and other macro-enabled formats?▼

This spreadsheet automation approach applies to .xlsx, .xlsm, and related formats, enabling programmatic workbook generation, data analysis, and automated recalculation across these file types.

What is the best way to ensure deterministic formula handling in Excel data analysis?▼

Ensure deterministic formula handling in Excel data analysis by using openpyxl for controlled formula definition and a LibreOffice-based recalc tool to automatically recalculate formulas and preserve template integrity.

How do I read and transform spreadsheet data without losing existing templates?▼

Read and transform spreadsheet data without losing existing templates by applying openpyxl for template preservation during data analysis, ensuring formatting and formulas remain intact throughout the editing process.