skills.rest
ynulihao
ynulihaoCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and analyze .xlsx, .xlsm, and .csv files with pandas and formula recalculation.

564|70|Updated Jan 25, 2026
Search Tags:#data analysis#pandas#openpyxl#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/ynulihao/AgentSkillOS --skill xlsx-ynulihao
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/ynulihao/AgentSkillOS/tree/main/data/skill_seeds/xlsx
Command: npx skills add https://github.com/ynulihao/AgentSkillOS --skill xlsx-ynulihao

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the creation, editing, and analysis of spreadsheet files, ensuring data integrity and dynamic calculations.

Core Features & Use Cases

  • Dynamic Formula Management: Create and edit spreadsheets with robust Excel formulas, ensuring calculations update automatically.
  • Data Analysis & Visualization: Leverage pandas for in-depth data analysis and prepare data for visualization.
  • Use Case: Automatically generate a financial projection spreadsheet, including complex formulas for revenue growth and expense calculations, based on provided assumptions.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'sales_report.xlsx' with columns for 'Date', 'Product', and 'Sales', and populate it with the provided data.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel spreadsheet with dynamic formulas for financial modeling?▼

To create an Excel spreadsheet with dynamic formulas, use this Skill to generate .xlsx files with robust formula management. It supports financial modeling by automatically updating calculations based on your provided assumptions for revenue and expenses.

Can I use pandas for data analysis on existing .xlsx and .csv files?▼

Yes, you can use pandas for data analysis on existing .xlsx and .csv files. This Skill leverages pandas for in-depth data aggregation and prepares your spreadsheet data for visualization, addressing scenarios requiring dynamic financial modeling.

What is the best way to ensure Excel formulas recalculate when editing spreadsheets?▼

The best way to ensure Excel formulas recalculate is using the built-in recalc.py script. This Skill mandates formula recalculation via LibreOffice, ensuring that all dynamic calculations in your .xlsx and .xlsm files update automatically without manual intervention.

Does this spreadsheet tool support .xlsm and .csv files for report generation?▼

Yes, this spreadsheet tool supports .xlsm and .csv files for report generation. It facilitates comprehensive operations including creation, editing, and analysis across these formats, allowing you to generate data aggregation reports and financial projections.

Why do my spreadsheet formulas not update automatically after data aggregation?▼

Spreadsheet formulas may not update automatically if formula recalculation is skipped. This Skill addresses this constraint by mandating formula recalculation using LibreOffice via recalc.py, ensuring data integrity and dynamic calculations after any data aggregation.

Related Skills

Explore More Finance & Accounting Skills→
fairwicfairwic
25

xlsx

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

Community
Advanced
imvladikonimvladikon
3

xlsx

Automate Excel workbook editing with formulas via openpyxl and pandas.

Community
Intermediate
wachawowachawo

xlsx

Creates, edits, and verifies Excel spreadsheets with pandas and openpyxl.

Community
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate