skills.rest
tankygranny05
tankygranny05COMMUNITY
Explore all skills by this author →
GitHub

document-skills:xlsx

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

2|Updated Jan 30, 2026
Search Tags:#formatting#data analysis#formulas#spreadsheet#excel#xlsx
One-click install
npx skills add https://github.com/tankygranny05/agent-box --skill document-skills-xlsx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: document-skills:xlsx
Source: https://github.com/tankygranny05/agent-box/tree/main/agent-box/seed/codex-skills/document-skills-xlsx
Command: npx skills add https://github.com/tankygranny05/agent-box --skill document-skills-xlsx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill streamlines the creation, modification, and analysis of spreadsheet files, eliminating manual data entry and complex formula management.

Core Features & Use Cases

  • Spreadsheet Creation & Editing: Generate new .xlsx files with custom formatting, formulas, and data.
  • Data Analysis: Utilize pandas for in-depth analysis, pivoting, and summarization of spreadsheet data.
  • Formula Management: Apply common Excel formulas and recalculate existing ones.
  • Use Case: Automatically generate a monthly sales report by reading raw data, applying SUM and AVERAGE formulas, and formatting the output into a professional .xlsx file.

Quick Start

Use the document-skills:xlsx skill to create a new spreadsheet named 'sales_report.xlsx' and add the header 'Month' to cell A1 with bold formatting.

Frequently Asked Questions about document-skills:xlsx

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

FAQPage Schema
How do I create an xlsx file with formulas and custom formatting?▼

To create an xlsx file with formulas and custom formatting, use this Skill to generate new spreadsheets, apply common Excel formulas, and define custom styling. It leverages openpyxl to handle file operations and deterministic formatting tasks.

Can I use pandas for data analysis on existing Excel spreadsheets?▼

Yes, you can use pandas for data analysis on existing Excel spreadsheets. This Skill enables in-depth analysis, pivoting, and summarization of spreadsheet data by utilizing pandas alongside xlrd to read and process your files.

What's the best way to automate generating a formatted sales report from raw data?▼

The best way to automate a formatted sales report from raw data is by reading the input, applying SUM and AVERAGE formulas, and formatting the output into a professional xlsx file. This Skill streamlines the entire creation and formula management process.

Does this spreadsheet manipulation approach support csv and tsv files?▼

Yes, this spreadsheet manipulation approach supports csv and tsv files in addition to xlsx and xlsm formats. It uses pandas and openpyxl libraries to ensure comprehensive file operations across these supported formats.

What limitations exist when recalculating Excel formulas with openpyxl?▼

When recalculating Excel formulas with openpyxl, the limitation is that operations are restricted to deterministic tasks. This ensures consistent formula creation and data processing, but complex dynamic recalculations may require specific pandas data handling.

Related Skills

Explore More Data & Analytics Skills→
gauravb4875-uxgauravb4875-ux

excel-generator

Automate Excel spreadsheet creation and manipulation using Python libraries.

Community
Advanced
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
KILWA73KILWA73

data-visualization

Generate publication-quality PNG charts from pre-processed numeric data using pandas, matplotlib, and seaborn.

Community
Advanced
luokai25luokai25

data-analyst

Analyze data with SQL, Python, and visualization tools for dashboards.

Community
Advanced