skills.rest
Kin3Xc
Kin3XcCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

xlsx

Create, edit, and analyze Excel-compatible spreadsheets with openpyxl and pandas.

Updated Jan 15, 2026
Search Tags:#Excel#pandas#openpyxl#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/Kin3Xc/promoly --skill xlsx-kin3xc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Kin3Xc/promoly/tree/main/skills/xlsx
Command: npx skills add https://github.com/Kin3Xc/promoly --skill xlsx-kin3xc

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of Excel-compatible spreadsheets, reducing manual toil and preserving formula integrity across templates.

Core Features & Use Cases

  • Automated spreadsheet creation with formulas and formatting
  • Data analysis, visualization, and reporting across .xlsx, .xlsm, .csv, and .tsv
  • Preservation of existing formulas when modifying templates
  • Formula recalculation support via a dedicated workflow

Quick Start

Create a new spreadsheet named 'sales_q1.xlsx' with two columns (Month, Revenue) and data for January through March; add a simple formula to sum Revenue; run recalc.py to update all formulas.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel spreadsheet creation while preserving formulas?▼

Automated spreadsheet creation while preserving formulas is handled by leveraging openpyxl and pandas to manipulate .xlsx and .xlsm files, ensuring existing formulas remain intact when templates are modified and recalculated.

What is the best way to recalculate formulas in an xlsx file without opening Excel?▼

Recalculating formulas in an xlsx file without opening Excel is achieved through a dedicated LibreOffice-based recalculation workflow, guaranteeing up-to-date results across your spreadsheet data.

Can I use pandas to read and analyze data from csv and tsv files?▼

Pandas is used to read and analyze data from csv and tsv files, providing data analysis, visualization, and reporting capabilities across these spreadsheet formats for analytical workflows.

Does openpyxl support editing existing Excel templates with formatting?▼

openpyxl supports editing existing Excel templates with formatting, allowing you to modify .xlsx workbooks while preserving their original formulas and layout structures during automated updates.

Why do my spreadsheet formulas not update when I write data with openpyxl?▼

Spreadsheet formulas written with openpyxl may not update automatically because openpyxl does not calculate formula results; a LibreOffice-based recalculation workflow is required to update them.

Related Skills

Explore More Data & Analytics Skills→
Qiue-GQiue-G

xlsx

Process and transform spreadsheet data across .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
Wesley1600Wesley1600

Excel Pivot Charts & Advanced Spreadsheet Skill

Create Excel workbooks with pivot tables, charts, and statistical analyses using Python libraries.

Community
Intermediate
cpalumbocpalumbo

xlsx

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

Community
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate