skills.rest
ShunmeiCho
ShunmeiChoCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas using Python and openpyxl.

2|Updated Jan 7, 2026
Search Tags:#openpyxl#formulas#spreadsheet#data-analysis#xlsx#LibreOffice#recalc
One-click install
npx skills add https://github.com/ShunmeiCho/dotclaude --skill xlsx-shunmeicho
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ShunmeiCho/dotclaude/tree/main/skills/xlsx
Command: npx skills add https://github.com/ShunmeiCho/dotclaude --skill xlsx-shunmeicho

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the lifecycle of Excel workbooks by enabling seamless creation, editing, and analysis of spreadsheets while preserving formulas and formatting.

Core Features & Use Cases

  • Create new workbooks with formulas and structured formatting.
  • Read, analyze, and transform data across .xlsx, .xlsm, .csv, and .tsv files.
  • Modify existing spreadsheets while preserving formulas, templates, and data integrity.
  • Recalculate formulas automatically after updates using the provided recalc.py tool.

Quick Start

Create or update a spreadsheet using Python and openpyxl, then run recalc.py to refresh all formulas:

  • Example: python recalc.py output.xlsx 30

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel workbook with formulas using Python?▼

You can create Excel workbooks with formulas using Python and the openpyxl library to construct new spreadsheets with structured formatting. The Skill enforces zero formula errors and documents hardcoded values during the creation process.

Does openpyxl recalculate formulas after updating an existing spreadsheet?▼

openpyxl does not recalculate formulas natively after updates. This Skill includes an optional recalc.py tool that leverages LibreOffice to automatically recalculate all formulas across the modified spreadsheet.

Can I edit an existing .xlsx file while preserving its original templates and formulas?▼

You can modify existing .xlsx spreadsheets while preserving formulas, templates, and data integrity. The Skill reads and transforms data across .xlsx, .xlsm, .csv, and .tsv files without breaking the original spreadsheet structure.

Do I need LibreOffice to read and analyze data from .csv and .tsv files?▼

You do not need LibreOffice to read and analyze .csv and .tsv files; Python with the openpyxl library handles data reading and transformation directly. LibreOffice is only required for the optional recalc.py tool to refresh formulas.

Why does my spreadsheet show stale formula values after editing it with openpyxl?▼

Spreadsheet formula values appear stale after openpyxl edits because the library does not automatically recalculate formulas upon saving. You must run the provided recalc.py tool with LibreOffice to refresh all formula values across the modified workbook.

Related Skills

Explore More Data & Analytics Skills→
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced
DevHive1DevHive1
18

excel-generator

Generate Excel workbooks with formatting, formulas, and charts using openpyxl and xlsxwriter.

Community
Intermediate
cf-gbroadycf-gbroady
14

nebulaone-usage-analytics-workbook-builder

Build usage analytics workbooks from nebulaONE export files using Python.

Community
Advanced
garethdainegarethdaine

spreadsheet

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate