skills.rest
dr-code
dr-codeCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and edit Excel workbooks with formulas, templates, and recalculation.

Updated Mar 18, 2026
Search Tags:#pandas#openpyxl#excel#xlsx#spreadsheet-automation#financial-modeling#formula-recalculation
One-click install
npx skills add https://github.com/dr-code/beacon --skill xlsx-dr-code
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/dr-code/beacon/tree/main/plugins/all-skills/skills/xlsx
Command: npx skills add https://github.com/dr-code/beacon --skill xlsx-dr-code

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates manual, error-prone spreadsheet work by enabling reliable creation, editing, and analysis of Excel workbooks while preserving formulas, formatting, and templates. It reduces the risk of broken models and ensures spreadsheets remain dynamic and auditable.

Core Features & Use Cases

  • Formula-first workflows: Build and modify workbooks using Excel formulas (not hardcoded values), enforce consistent formula patterns, and validate for common errors.
  • Template preservation: Update existing .xlsx/.xlsm templates without changing established formatting, styles, or conventions.
  • Recalculation and validation: Use the included recalc.py script with LibreOffice to recalculate formulas and detect Excel errors before delivery.
  • Data analysis and interoperability: Use pandas for bulk data manipulation and openpyxl for precise formula and formatting control; ideal for monthly budgets, financial models, pivot-chart reporting, and CSV/TSV ingestion.

Quick Start

Create a monthly budget workbook with formulas, conditional formatting, and automatic recalculation using the xlsx skill.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel creation and analysis without breaking existing formulas and formatting?▼

Automating Excel creation and analysis without breaking formulas requires a formula-first approach using openpyxl for precise formatting control and pandas for bulk data manipulation. This ensures .xlsx templates remain dynamic and auditable while preserving established styles.

Can I use Python to edit .xlsm files and run formula recalculation for financial models?▼

Python can edit .xlsm files and run formula recalculation for financial models by leveraging openpyxl for modifications and executing LibreOffice-based recalculation via a recalc.py script. This validates formulas and detects Excel errors before workbook delivery.

Does pandas work with openpyxl to ingest CSV and TSV files into Excel workbooks?▼

Pandas works with openpyxl to ingest CSV and TSV files into Excel workbooks for data analysis and interoperability. Pandas handles bulk data manipulation while openpyxl applies precise formula controls and conditional formatting to the final output.

What is the best way to generate Excel pivot-chart reports and avoid hardcoded values?▼

The best way to generate Excel pivot-chart reports and avoid hardcoded values is enforcing consistent formula patterns through a formula-first workflow. Using Excel formulas instead of static values ensures spreadsheets stay dynamic, auditable, and free of common errors.

Why do my spreadsheet automation scripts overwrite template formatting when updating workbooks?▼

Spreadsheet automation scripts overwrite template formatting because they lack precise style preservation controls. Using openpyxl enables updating existing .xlsx and .xlsm templates while strictly preserving established formatting, styles, and conventions without hardcoding values.

Related Skills

Explore More Finance & Accounting Skills→
mainza-aimainza-ai
83

xlsx

Open, edit, and convert XLSX, CSV, and TSV spreadsheet files.

Community
Advanced
vasilyu1983vasilyu1983
73

document-xlsx

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

Community
Advanced
AndersHsuehAndersHsueh

xlsx

Create, edit, and analyze Excel workbooks with Python and LibreOffice recalculation.

Community
Advanced
jasrajtulsijasrajtulsi

xlsx

Create, edit, and analyze Excel workbooks while preserving formulas and formatting.

Community
Advanced