xlsx

Create Excel files with live formulas using openpyxl.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/GrilledSword/claude-office-skills --skill xlsx-grilledsword
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/GrilledSword/claude-office-skills/tree/main/public/xlsx
Command: npx skills add https://github.com/GrilledSword/claude-office-skills --skill xlsx-grilledsword

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, and time-consuming manual work involved in creating, editing, and analyzing spreadsheets, especially when dealing with complex formulas and formatting.

Core Features & Use Cases

  • Formula-Driven Spreadsheets: Generate dynamic Excel files with live formulas, ensuring data integrity and recalculation capabilities.
  • Data Analysis & Visualization: Leverage powerful Python libraries like pandas for in-depth data manipulation and insights within spreadsheets.
  • Error-Free Outputs: Automated validation and recalculation processes guarantee that all generated or modified spreadsheets are free from common formula errors.
  • Use Case: Imagine you need to generate monthly financial reports for 50 different departments. This Skill can automate the creation of each department's spreadsheet, ensuring all formulas are correct and data is accurately visualized, saving you days of manual work and review.

Quick Start

Example: Create a new Excel file with a formula

from openpyxl import Workbook wb = Workbook() sheet = wb.active sheet['A1'] = 'Revenue' sheet['B1'] = 1000 sheet['B2'] = '=B1*1.05' # 5% growth wb.save('report.xlsx')