skills.rest
Ber-tx
Ber-txCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

Updated May 21, 2026
Search Tags:#automation#financial modeling#data analysis#Excel#pandas
One-click install
npx skills add https://github.com/Ber-tx/tongue --skill xlsx-ber-tx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Ber-tx/tongue/tree/main/.github/skills-main/skills/xlsx
Command: npx skills add https://github.com/Ber-tx/tongue --skill xlsx-ber-tx

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, pyxlsb, xlrd, xlwt, xlutils, xlwtstyles, xlrd.xlrd, xlutils.copy, python-dateutil, xlutils.book, openpyxl.reader.excel, openpyxl.writer.excel, openpyxl.styles, openpyxl.chart, openpyxl.drawing, openpyxl.shared, openpyxl.utils, openpyxl.workbook, openpyxl.worksheet, openpyxl.xml, openpyxl.xml.writer, openpyxl.xml.reader, openpyxl.xmlNS, openpyxl.xmlns, openpyxl.xmlnsBase, openpyxl.xmlnsBase, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines Excel workflows, enabling users to automate complex tasks, analyze data, and maintain accuracy with minimal effort.

Core Features & Use Cases

  • Excel File Operations: Open, read, edit, and fix .xlsx, .xlsm, .csv, or .tsv files.
  • Data Analysis: Utilize pandas for data manipulation, visualization, and basic operations.
  • Financial Modeling: Implement industry-standard color coding, number formatting, and formula construction rules.
  • Use Case: If you have a financial model with numerous formulas and assumptions, this Skill can help automate the recalculations, ensuring accuracy and saving time.

Quick Start

Use the xlsx skill to open and recalculate a financial model contained in 'model.xlsx'.

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 editing and data analysis with pandas?▼

You can automate Excel file editing and data analysis by using pandas to manipulate data and openpyxl to handle advanced formatting and formulas within .xlsx, .xlsm, .csv, or .tsv files.

What is the best way to recalculate formulas in a financial model?▼

To recalculate formulas in a financial model, you need to use LibreOffice for recalculations alongside openpyxl for constructing and managing industry-standard formulas and formatting.

Does openpyxl support modifying formulas and advanced formatting in Excel?▼

Yes, openpyxl supports modifying formulas and applying advanced formatting in Excel, while pandas handles the underlying data manipulation and visualization for your analysis workflows.

Can I use this approach to open and fix corrupted .xlsm or .xlsx files?▼

Yes, this approach allows you to open, read, edit, and fix .xlsx, .xlsm, .csv, or .tsv files by leveraging openpyxl and pandas to repair data and formula structures.

Do I need LibreOffice to automate Excel workflows with openpyxl?▼

You need LibreOffice specifically for formula recalculations in your Excel workflows, whereas openpyxl and pandas handle file operations, data analysis, and advanced cell formatting independently.

What are the limitations of using pandas for financial modeling?▼

While pandas excels at data manipulation and visualization, it relies on openpyxl for advanced Excel formatting and LibreOffice for formula recalculations, meaning complex formula updates require external tools.

Related Skills

Explore More Software Engineering Skills→
iiammaeiiammae

xlsx

Open, read, edit, and convert Excel spreadsheet files with openpyxl and pandas.

Community
Advanced
omicverseomicverse
32

data-export-excel

Export pandas DataFrames and AnnData tables to styled Excel workbooks.

Official
Intermediate
Science-DiscoveryScience-Discovery
71

Excel Analysis

Automate Excel data analysis and visualization with pandas, openpyxl, and matplotlib.

Official
Intermediate
robertbr123robertbr123

excel-author

Automate Excel workbook creation with formulas, named ranges, and cell formatting.

Community
Advanced