skills.rest
freestylefly
freestyleflyCOMMUNITY
Explore all skills by this author →
Website𝕏@cangheGitHub

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
One-click install
npx skills add https://github.com/freestylefly/wesight --skill xlsx-freestylefly
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
eduardoabreu81eduardoabreu81
6

xlsx

Create and analyze XLSX workbooks with openpyxl, validating formulas and recalculations.

Community
Advanced
TouricksTouricks
4

xlsx

Create, edit, and analyze spreadsheets across xlsx, xlsm, csv, and tsv formats.

Community
Advanced
sergeyitalysergeyitaly
1

xlsx

Create, edit, and analyze Excel files with openpyxl and pandas.

Community
Advanced
AIDotNetAIDotNet
602

xlsx

Create, edit, and audit Excel workbooks with formula validation.

Official
Advanced