skills.rest
baoduo158
baoduo158COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, analyze, and visualize Excel files with Python libraries.

1|Updated Jun 8, 2026
Search Tags:#financial modeling#data analysis#spreadsheet#excel#scriptable
One-click install
npx skills add https://github.com/baoduo158/hsp-claude-man --skill xlsx-baoduo158
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/baoduo158/hsp-claude-man/tree/main/base-skills/xlsx
Command: npx skills add https://github.com/baoduo158/hsp-claude-man --skill xlsx-baoduo158

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides comprehensive control over Excel files, automating common tasks, and simplifying complex operations to save time and reduce errors.

Core Features & Use Cases

  • Excel File Creation and Editing: Build new spreadsheets from scratch or modify existing ones with precision.
  • Data Analysis and Visualization: Perform in-depth data analysis and visualize results with charts and graphs.
  • Use Case: If you need to create financial models or analyze sales data, this Skill can assist with everything from setting up the structure to performing calculations and visualizing the results.

Quick Start

Use the xlsx skill to create a new spreadsheet from the provided data and add a chart showing the sales trends.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel file creation and data analysis with Python?▼

Automating Excel file creation and data analysis with Python involves using libraries like openpyxl and pandas to build spreadsheets and manipulate data. This automates common tasks to reduce errors and save time.

Can I use Python to generate charts and visualize spreadsheet data?▼

Yes, you can use Python to generate charts and visualize spreadsheet data by leveraging the matplotlib library. This allows you to perform in-depth data analysis and visualize results directly within your Excel files.

Do I need LibreOffice to recalculate formulas in my Excel files?▼

Yes, you need LibreOffice to recalculate formulas in your Excel files. The system relies on LibreOffice specifically for formula recalculation, while openpyxl and pandas handle data manipulation.

What is the best way to script financial modeling in Excel?▼

The best way to script financial modeling in Excel is using a scriptable interface that combines pandas for data manipulation and openpyxl for spreadsheet structure. This allows you to build models and perform calculations automatically.

How do I edit existing spreadsheets programmatically without losing formatting?▼

To edit existing spreadsheets programmatically without losing formatting, use openpyxl to modify Excel files with precision. This allows you to manipulate data and create formulas while maintaining the original structure.

Related Skills

Explore More Software Engineering Skills→
cbbkrd-techcbbkrd-tech

xlsx

Create, edit, and analyze .xlsx, .xlsm, .csv, and .tsv files with pandas and openpyxl.

Community
Advanced
EdgeHuntEdgeHunt

ck:xlsx

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

Official
Advanced
cuozgcuozg
4

spreadsheet

Automate spreadsheet creation, editing, analysis, and formatting in .xlsx, .csv, and .tsv.

Community
Intermediate
kinnerkarmanishkinnerkarmanish

cli-anything

Transform GUI applications into scriptable CLIs via a seven-phase pipeline.

Community
Advanced