skills.rest
OpenAgentsInc
OpenAgentsIncOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Create and modify Excel spreadsheets with formulas and formatting.

445|61|Updated Nov 7, 2023
Search Tags:#automation#financial modeling#data analysis#pandas#openpyxl#spreadsheet#excel
One-click install
npx skills add https://github.com/OpenAgentsInc/openagents --skill xlsx-openagentsinc
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/OpenAgentsInc/openagents/tree/main/skills/document-skills/xlsx
Command: npx skills add https://github.com/OpenAgentsInc/openagents --skill xlsx-openagentsinc

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the tedious, error-prone manual work of spreadsheet creation, editing, and analysis. It ensures data accuracy, preserves complex formatting, and automates formula recalculations, saving hours of repetitive tasks, especially in financial modeling.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new Excel files with formulas and precise formatting, ensuring the spreadsheet remains dynamic and updateable, not just static data.
  • Data Analysis & Modification: Read, analyze, and modify existing spreadsheets using powerful Python libraries like pandas for data manipulation and openpyxl for structural changes.
  • Formula Recalculation & Validation: Automatically recalculate all formulas in a spreadsheet and detect common errors (e.g., #REF!, #DIV/0!) to guarantee data integrity.
  • Use Case: A finance analyst needs to update a quarterly earnings model with new data. This skill can load the existing .xlsx file, update raw figures, recalculate all dependent formulas, and ensure all financial reporting standards (like color coding and number formatting) are met, all while preserving the original template's style and structure.

Quick Start

To create a new Excel file with a sum formula and then recalculate it:

  1. Create output.xlsx with a formula: from openpyxl import Workbook; wb = Workbook(); sheet = wb.active; sheet['A1'] = 10; sheet['A2'] = 20; sheet['A3'] = '=SUM(A1:A2)'; wb.save('output.xlsx')
  2. Recalculate formulas and check for errors: python recalc.py output.xlsx