skills.rest
leduclinh7141
leduclinh7141COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Automate XLSX spreadsheet creation, editing, and analysis with formulas and templates.

Updated Aug 23, 2026
Search Tags:#automation#formulas#spreadsheet#excel#xlsx#recalculation
One-click install
npx skills add https://github.com/leduclinh7141/aitykit-marketing --skill xlsx-leduclinh7141
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/leduclinh7141/aitykit-marketing/tree/main/.claude/skills/document-skills/xlsx
Command: npx skills add https://github.com/leduclinh7141/aitykit-marketing --skill xlsx-leduclinh7141

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) components.

What problem does it solve?

This Skill enables Excel/Spreadsheet automation, including formula recalculation, data transformation, and preserving templates during updates.

Core Features & Use Cases

  • Zero-formula errors and dynamic workbook updates
  • Recalculate formulas using LibreOffice macro (via recalc.py)
  • Preserve and apply existing templates and formatting
  • Data extraction and transformation through Python scripts

Quick Start

Open model.xlsx and recalc all formulas, then export the workbook to HTML.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula recalculation in Python?▼

Automate Excel formula recalculation by using openpyxl to modify XLSX workbooks, then trigger recalculation through LibreOffice via the recalc.py workflow. This ensures formulas update without manual intervention and eliminates formula errors.

Can I preserve formatting and templates when editing XLSX files programmatically?▼

Yes. This Skill preserves existing templates, color conventions, and formatting while modifying spreadsheets through Python scripts, so your workbook structure and styling remain intact during updates.

What's the best way to extract and transform data from Excel spreadsheets?▼

Extract and transform data by reading XLSX files with openpyxl, applying Python-based data analysis and transformation logic, then export results to formats like HTML or modified workbooks for downstream use.

How do I create new Excel workbooks with formulas and formatting from scratch?▼

Create new XLSX workbooks programmatically using openpyxl to define formulas, apply formatting, and structure data, then use the recalc.py workflow to validate and recalculate all formulas before export.

Does this approach work for large-scale spreadsheet automation?▼

Yes. The Skill handles spreadsheet automation at scale through Python scripts and LibreOffice recalculation, supporting zero-formula-error requirements and template preservation across multiple workbooks.

What are the limitations when automating complex Excel formulas?▼

Recalculation relies on LibreOffice macro execution via recalc.py, so extremely complex or Excel-specific formulas may require validation. Ensure your environment has LibreOffice available and formulas are compatible with the recalculation workflow.

Related Skills

Explore More Data & Analytics Skills→
MacPhobosMacPhobos

Excel/XLSX Manipulation

Read, write, transform, and format Excel XLSX files in Python and JavaScript.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

chart-embedded-export

Extract classification distributions, clean text, and compute cross-tabulated statistics for analysis reports.

Community
Advanced
caoronglincaoronglin
2

xlsx

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

Community
Advanced
zeroix07zeroix07

xlsx

Create, edit, analyze, and convert Excel files with Python and openpyxl.

Community
Advanced