skills.rest
levanminhduc
levanminhducCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Updated Jul 23, 2025
Search Tags:#data analysis#formulas#xlsx#excel automation#spreadsheet editing
One-click install
npx skills add https://github.com/levanminhduc/LuongHoaThoNew --skill xlsx-levanminhduc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/levanminhduc/LuongHoaThoNew/tree/main/.claude/skills/xlsx
Command: npx skills add https://github.com/levanminhduc/LuongHoaThoNew --skill xlsx-levanminhduc

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization to reclaim time spent on manual Excel tasks.

Core Features & Use Cases

  • Spreadsheet creation & editing: Build new workbooks and modify existing ones while preserving formulas.
  • Data analysis & visualization: Analyze data and prepare visuals directly in spreadsheets.
  • Deterministic recalculation: Recalculate formulas deterministically using provided scripts to ensure accuracy across updates.

Quick Start

Use the xlsx skill to recalculate formulas in an Excel file (e.g., workbook.xlsx) and verify zero errors.

Frequently Asked Questions about xlsx

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

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

Excel formula recalculation automates spreadsheet updates by recalculating formulas deterministically across .xlsx, .xlsm, .csv, and .tsv files using provided scripts to ensure zero formula errors and accuracy after modifications.

Can I edit Excel templates while preserving existing formulas?▼

Yes, you can modify Excel templates while preserving formulas by automating spreadsheet editing on .xlsx and .xlsm files, ensuring formulas remain intact and recalculate correctly without manual intervention.

How do I create Excel spreadsheets with formulas and formatting programmatically?▼

Spreadsheet creation with formulas and formatting programmatically builds new .xlsx workbooks with formula-driven calculations and formatting conventions applied automatically, eliminating manual formula entry and ensuring consistency.

Does openpyxl support data analysis and visualization in Excel files?▼

openpyxl enables data analysis and visualization by automating spreadsheet analysis on Excel formats, integrating with pandas for data handling and recalculation tools to transform and display data directly in workbooks.

What file formats can I work with for spreadsheet automation?▼

Spreadsheet automation supports .xlsx, .xlsm, .csv, and .tsv formats, enabling comprehensive editing, formula recalculation, and data analysis across multiple spreadsheet file types in a unified workflow.

How do I verify Excel workbooks have zero formula errors after updates?▼

Formula error verification automatically recalculates formulas deterministically using provided scripts on updated .xlsx and .xlsm files, confirming zero errors and maintaining template integrity across modifications.

Related Skills

Explore More Data & Analytics Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
TIAN0517TIAN0517

xlsx

Create, edit, and analyze spreadsheets while preserving formulas across .xlsx and .xlsm formats.

Community
Advanced
colinmxscolinmxs

xlsx

Create, edit, and analyze Excel workbooks with formulas and formatting.

Community
Intermediate
Mhafis99Mhafis99

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas via openpyxl and LibreOffice.

Community
Advanced