skills.rest
joneqian
joneqianCOMMUNITY
Explore all skills by this author →
GitHub

Excel / XLSX

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

1|Updated Mar 12, 2026
Search Tags:#templates#formatting#formulas#excel#xlsx#workbooks
One-click install
npx skills add https://github.com/joneqian/EvoClaw --skill excel-xlsx-joneqian
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Excel / XLSX
Source: https://github.com/joneqian/EvoClaw/tree/main/packages/core/src/skill/bundled/excel-xlsx
Command: npx skills add https://github.com/joneqian/EvoClaw --skill excel-xlsx-joneqian

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, .xlsx, .xlsm, .xls, .csv, or .tsv; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits.

Core Features & Use Cases

  • Manage and automate core Excel workflows: create, inspect, and edit workbooks while preserving formulas, styles, and structure.
  • Handle date serialization, numeric precision, and data types to avoid common Excel pitfalls.
  • Use cases include building templates, validating workbook integrity after updates, and converting between formats while maintaining fidelity.

Quick Start

Use this skill to generate or modify an Excel workbook with preserved formulas and consistent formatting.

Frequently Asked Questions about Excel / XLSX

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

FAQPage Schema
How do I automate Excel workbooks while preserving formulas and formatting?▼

Automate Excel workbooks reliably by using openpyxl and pandas to inspect, create, and edit .xlsx files while preserving formulas, styles, and workbook structure. This prevents common issues like broken calculations and lost template formatting during automated edits.

Why does Excel date serialization break when editing xlsx files with pandas?▼

Excel date serialization breaks due to mismatched data types and numeric precision limits. Handling dates and data types through openpyxl ensures correct date serialization and validates workbook integrity, avoiding common Excel pitfalls during xlsx file modifications.

Can I use openpyxl to edit xlsm and csv files without breaking cross-platform compatibility?▼

Yes, you can edit .xlsm and .csv files while maintaining cross-platform compatibility. The process validates data types and preserves workbook structure, ensuring files stay reliable and correctly formatted across different platforms after updates.

What is the best way to convert csv to xlsx while maintaining template fidelity?▼

The best way to convert .csv to .xlsx while maintaining template fidelity is using pandas and openpyxl. This approach manages numeric precision, applies consistent styles, and validates data types to ensure the converted workbook retains its original structure and reliable formulas.

Does automating xlsx workbook structure with openpyxl support template preservation?▼

Yes, automating workbook structure with openpyxl supports template preservation. It inspects and edits worksheets while explicitly maintaining formulas, styles, and overall workbook structure, ensuring your templates remain intact and reliable after any automated modifications.

Limitations of using pandas for Excel formulas and workbook recalculation?▼

Pandas limitations for Excel formulas include lacking native formula preservation and recalculation capabilities. To avoid broken calculations and ensure reliable formulas, complement pandas with openpyxl to inspect, validate, and edit workbook structures and data types properly.

Related Skills

Explore More Data & Analytics Skills→
mofa-orgmofa-org
11

xlsx

Automate Excel workbook creation, editing, and analysis with formulas and formatting.

Official
Advanced
bmadiganbmadigan
1

xlsx

Create, edit, and analyze Excel workbooks with openpyxl and pandas.

Community
Intermediate
KILWA73KILWA73

data-visualization

Generate publication-quality PNG charts from pre-processed numeric data using pandas, matplotlib, and seaborn.

Community
Advanced
koolamusickoolamusic
9

xlsx

Create and edit Excel workbooks with formula validation via LibreOffice recalculation.

Community
Advanced