skills.rest
TW-NLP
TW-NLPCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

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

91|11|Updated Jan 15, 2026
Search Tags:#financial modeling#data analysis#pandas#spreadsheet#excel
One-click install
npx skills add https://github.com/TW-NLP/DeepAgentForce --skill xlsx-tw-nlp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/TW-NLP/DeepAgentForce/tree/main/src/services/skills/document/xlsx
Command: npx skills add https://github.com/TW-NLP/DeepAgentForce --skill xlsx-tw-nlp

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, scripts/recalc.py, scripts/office, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of Excel files, ensuring accuracy and efficiency in spreadsheet management.

Core Features & Use Cases

  • Excel File Creation: Start from scratch or convert existing data into a new Excel file.
  • Data Editing: Modify data, apply formulas, and format cells to meet specific requirements.
  • Analysis: Utilize pandas for data analysis and visualization, with direct support for common data operations.
  • Use Case: Suppose you have a dataset in a CSV file and need to perform various calculations and generate charts. This Skill allows you to load the data, apply formulas, and create a detailed financial report in Excel.

Quick Start

Use the xlsx skill to open the 'budget.xlsx' file, apply the formula to calculate the total expenses for each category, and format the output with a conditional color coding for high priority items.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a CSV file into a formatted Excel financial report?▼

To convert a CSV file into an Excel financial report, you can use pandas to load the dataset, apply formulas for calculations, and format output cells to generate the final spreadsheet.

Can I use pandas with openpyxl for Excel data analysis and editing?▼

Yes, you can use pandas for data manipulation and openpyxl for direct Excel file manipulation, allowing you to analyze datasets and edit spreadsheets with precision.

Does LibreOffice support Excel formula recalculation for financial modeling?▼

Yes, LibreOffice integration supports formula recalculation, ensuring formulas applied during your financial modeling workflows calculate correctly within generated Excel files.

What is the best way to apply conditional formatting to an Excel spreadsheet?▼

The best way to apply conditional formatting to an Excel spreadsheet is by using openpyxl for direct cell manipulation, allowing you to apply color coding based on specific data values.

How do I calculate total expenses across categories in a budget spreadsheet?▼

To calculate total expenses in a budget spreadsheet, load your data and apply formulas to sum values for each category, utilizing spreadsheet formula recalculation to verify results.

Related Skills

Explore More Finance & Accounting Skills→
cas-bigdatalabcas-bigdatalab
541

data_merge_concat

Vertically merge CSV, TSV, Excel, and SPSS files into one file.

Official
Intermediate
OpenSenseNovaOpenSenseNova
4.9k

excel-data-analysis-and-report-generation

Analyze Excel data and generate statistical reports with charts.

Official
Intermediate
bowoxdailybowoxdaily

xlsx

Analyze Excel files and generate reports using Python and openpyxl.

Community
Advanced
chenguojun06-starchenguojun06-star
1

lark-sheets

Create, edit, search, and export Feishu spreadsheet data via lark-cli.

Community
Advanced