skills.rest
7th-ave-labs
7th-ave-labsOFFICIAL
Explore all skills by this author →
GitHub

xlsx

Create and modify .xlsx spreadsheets with formulas and formatting.

Updated Aug 23, 2026
Search Tags:#automation#financial modeling#reporting#data analysis#excel#xlsx#spreadsheets
One-click install
npx skills add https://github.com/7th-ave-labs/document-skills --skill xlsx-7th-ave-labs
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/7th-ave-labs/document-skills/tree/main/document-skills/xlsx
Command: npx skills add https://github.com/7th-ave-labs/document-skills --skill xlsx-7th-ave-labs

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manual spreadsheet work is time-consuming, error-prone, and often involves repetitive data entry or complex formula management. This Skill automates comprehensive Excel operations, ensuring accuracy, consistency, and freeing up your time for strategic analysis.

Core Features & Use Cases

  • Dynamic Spreadsheet Creation: Generate new .xlsx files with formulas, formatting, and data validation, ensuring your models are always dynamic and updateable.
  • Intelligent Data Analysis: Read, analyze, and modify existing spreadsheets while preserving formulas, formatting, and structural integrity.
  • Error-Free Financial Models: Build and update financial models with strict adherence to industry standards, including color coding, number formatting, and formula construction, guaranteeing zero formula errors.
  • Use Case: Automatically generate a quarterly sales report in Excel, complete with pivot tables, charts, and conditional formatting, based on raw sales data from a CSV, and ensure all formulas are correctly recalculated.

Quick Start

Use the xlsx skill to create a new spreadsheet named 'quarterly_report.xlsx' with sales data for Q1, Q2, Q3, and Q4, and include a sum formula for total sales.