skills.rest
tmtgroupbot
tmtgroupbotCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel spreadsheets with formulas, formatting, and charts using openpyxl and pandas.

Updated Mar 30, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/tmtgroupbot/lptracker-deploy --skill xlsx-tmtgroupbot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/tmtgroupbot/lptracker-deploy/tree/main/skills/xlsx
Command: npx skills add https://github.com/tmtgroupbot/lptracker-deploy --skill xlsx-tmtgroupbot

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Working with spreadsheets programmatically often leads to broken formulas, inconsistent formatting, and files that fail to recalculate. This Skill provides a complete workflow for building, editing, and validating Excel files so every workbook arrives with zero formula errors and professional styling. ## Core Features & Use Cases - Spreadsheet Creation & Editing: Build new .xlsx workbooks or modify existing ones with openpyxl while preserving formulas, styles, and template conventions. - Data Analysis & Visualization: Use pandas to read, analyze, and transform spreadsheet data, then export results with charts and formatted tables. - Formula Recalculation & Validation: Run the included recalc.py script with LibreOffice to compute formula values and detect errors like #REF!, #DIV/0!, and #NAME? with exact cell locations. - Use Case: Ask for a three-year financial model with revenue projections, and receive a workbook with live Excel formulas, industry-standard color coding (blue inputs, black formulas), and verified error-free calculations. ## Quick Start Create an Excel file with a sales summary table, a growth-rate formula column, and a bar chart, then recalculate and verify all formulas.

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 file with formulas in Python?▼

Use openpyxl to write formulas as strings, such as sheet['B10'] = '=SUM(B2:B9)', then save the workbook. Always use Excel formulas instead of hardcoding Python-calculated values so the spreadsheet recalculates when source data changes.

Should I use pandas or openpyxl for Excel files?▼

Use pandas for data analysis, bulk operations, and simple exports via read_excel and to_excel. Use openpyxl when you need formulas, cell formatting, charts, or edits to existing files that must preserve styles and structure.

Why do openpyxl formulas show no values in Excel charts?▼

openpyxl writes formulas as strings without computed values, so charts referencing them appear blank. Run the recalc.py script, which uses LibreOffice to recalculate all formulas and store cached values before charting.

How do I fix #REF! and #DIV/0! errors in generated Excel files?▼

Run recalc.py on the file to get a JSON report listing each error type with exact cell locations. Fix invalid references, guard divisions against zero denominators, and rerun the script until the status is success.

Can openpyxl edit an existing spreadsheet without losing formulas?▼

Yes, load the file with load_workbook and modify cells, rows, or sheets directly. Avoid opening with data_only=True before saving, since that replaces formulas with their cached values permanently.

Related Skills

Explore More Data & Analytics Skills→
EdgeHuntEdgeHunt

ck:xlsx

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheets with formulas and pivot tables.

Official
Advanced
AIDotNetAIDotNet
602

excel-processor

Read, write, format, and analyze Excel workbooks with Python and openpyxl.

Official
Intermediate
xpert-aixpert-ai
8

enrich-company-and-contact-data

Enrich company and contact data with confidence scoring and source attribution.

Official
Advanced
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate