skills.rest
HanLi0705
HanLi0705COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze Excel workbooks across .xlsx, .xlsm, .csv, and .tsv formats.

1|Updated Dec 22, 2025
Search Tags:#automation#visualization#Excel#formulas#spreadsheet#data-analysis#xlsx
One-click install
npx skills add https://github.com/HanLi0705/lead_agent --skill xlsx-hanli0705
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/HanLi0705/lead_agent/tree/main/Mini-Agent-main/mini_agent/skills/document-skills/xlsx
Command: npx skills add https://github.com/HanLi0705/lead_agent --skill xlsx-hanli0705

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates Excel workbook creation, editing, and analysis, preserving formulas, applying consistent formatting, and enabling data-driven insights to reduce manual spreadsheet chores.

Core Features & Use Cases

  • Create new spreadsheets with formulas and formatting to model financials, budgets, and data dashboards.
  • Read, analyze, and summarize data across sheets, export insights to CSV or charts.
  • Modify existing spreadsheets while preserving existing formulas and templates, and support data visualization within the workbook.
  • Recalculate and validate formulas using LibreOffice via recalc.py to ensure model integrity.

Quick Start

Create a new workbook with sample data and a simple formula, then run recalc.py to refresh 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 workbook creation with formulas and formatting?▼

This Skill automates Excel workbook creation by generating new spreadsheets, applying consistent formatting, inserting formulas, and building financial or budget models directly within .xlsx files.

Can I modify existing Excel spreadsheets while preserving formulas?▼

Yes, this Skill modifies existing spreadsheets while preserving formulas and templates, allowing you to update data, apply formatting, and add visualizations without breaking existing Excel calculations.

Does this tool support data visualization and recalculation in .xlsx files?▼

Yes, this Skill supports data visualization within workbooks and recalculates formulas using LibreOffice via recalc.py, ensuring model integrity and accurate data analysis across your spreadsheets.

What spreadsheet formats can I read and analyze with this automation tool?▼

This Skill reads, analyzes, and summarizes data across .xlsx, .xlsm, .csv, and .tsv formats, exporting insights to CSV or charts for comprehensive spreadsheet data analysis.

How do I recalculate and validate formulas in an Excel workbook?▼

You recalculate and validate formulas by running recalc.py via this Skill, which leverages LibreOffice to refresh all calculations in your Excel workbook, ensuring model integrity and accurate formula results.

Related Skills

Explore More Data & Analytics Skills→
Jaydpatel01Jaydpatel01

xlsx

Create, edit, and analyze spreadsheet files in .xlsx, .xlsm, .csv, and .tsv formats.

Community
Advanced
lazygopherslazygophers
4

office-xlsx-skills

Read, write, analyze, and convert Excel, CSV, and JSON files.

Official
Advanced
OpenSenseNovaOpenSenseNova
4.9k

pie-chart-data-analysis

Analyze Excel or CSV data and generate pie chart reports.

Official
Intermediate
EATSTEAKEATSTEAK

xlsx

Create and edit Excel spreadsheets with pandas and openpyxl.

Community
Advanced