skills.rest
LISANG3
LISANG3COMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

1|Updated Feb 13, 2026
Search Tags:#automation#financial modeling#data analysis#pandas#openpyxl#spreadsheet#excel
One-click install
npx skills add https://github.com/LISANG3/Larj --skill xlsx-lisang3
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/LISANG3/Larj/tree/main/skills/.agents/skills/xlsx
Command: npx skills add https://github.com/LISANG3/Larj --skill xlsx-lisang3

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, automating complex calculations, formatting, and data manipulation tasks.

Core Features & Use Cases

  • Formula Creation & Management: Generates Excel formulas instead of hardcoding values, ensuring dynamic and updateable spreadsheets.
  • Data Analysis & Formatting: Utilizes pandas for data manipulation and openpyxl for formatting and formula application.
  • Use Case: Automatically create a financial model with industry-standard color coding and number formatting, or clean messy tabular data from a CSV file into a structured Excel report.

Quick Start

Use the xlsx skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Revenue'.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel formula creation instead of hardcoding values?▼

To automate Excel formula creation, this Skill generates dynamic formulas instead of hardcoded values using openpyxl. It ensures spreadsheets remain updateable and error-free by verifying formulas through LibreOffice recalculation.

Can I use pandas to clean messy CSV data and export a formatted Excel report?▼

Yes, you can use pandas to clean messy CSV data and export a formatted Excel report. This Skill manipulates tabular data with pandas and applies professional formatting using openpyxl to create structured .xlsx files.

What is the best way to build an Excel financial model with professional formatting standards?▼

The best way to build an Excel financial model is by automating it with this Skill, which applies industry-standard color coding and number formatting. It uses pandas for data manipulation and openpyxl for precise spreadsheet formatting.

Do I need LibreOffice to recalculate Excel formulas generated via openpyxl?▼

Yes, you need LibreOffice to recalculate Excel formulas generated via openpyxl. The Skill requires LibreOffice to execute its recalculation script, ensuring all dynamically generated formulas are computed correctly without manual intervention.

Why does my openpyxl generated spreadsheet show incorrect or uncalculated formula values?▼

Uncalculated formula values in an openpyxl generated spreadsheet occur because Python does not natively compute Excel formulas. This Skill solves this limitation by running a LibreOffice script to force formula recalculation and verify error-free outputs.

Related Skills

Explore More Finance & Accounting Skills→
skycruzerskycruzer

XLSX

Automates Excel spreadsheet creation, editing, and pandas-based analysis with LibreOffice recalculation.

Community
Intermediate
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced
ChatAndBuildChatAndBuild
1

xlsx

Automate Excel spreadsheet creation, editing, and analysis with pandas and openpyxl.

Official
Advanced