skills.rest
KnoWhiz
KnoWhizOFFICIAL
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Create, edit, analyze, and format spreadsheet files using Python libraries.

6|Updated Jan 29, 2026
Search Tags:#automation#reporting#data analysis#formulas#spreadsheet#excel
One-click install
npx skills add https://github.com/KnoWhiz/DoWhiz --skill spreadsheet-knowhiz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/KnoWhiz/DoWhiz/tree/main/.agents/skills/spreadsheet
Command: npx skills add https://github.com/KnoWhiz/DoWhiz --skill spreadsheet-knowhiz

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill automates the creation, editing, analysis, and formatting of spreadsheet files, streamlining data manipulation and reporting tasks.

Core Features & Use Cases

  • Workbook Creation & Editing: Generate new spreadsheets or modify existing ones with formulas, formatting, and data.
  • Data Analysis: Perform calculations, aggregations, and generate insights from tabular data.
  • Visualization: Create charts and format sheets for clear visual representation.
  • Use Case: Automatically generate a monthly sales report by pulling data from a CSV, applying formulas for totals and growth percentages, and formatting it for presentation.

Quick Start

Use the spreadsheet skill to create a new Excel file named 'sales_report.xlsx' with columns for 'Month', 'Revenue', and 'Profit'.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel report generation from a CSV file?▼

Automate Excel report generation by using Python libraries like pandas to read CSV files and openpyxl to apply formulas, calculate aggregations, and format spreadsheets for presentation.

Can I modify an existing spreadsheet while preserving its formulas?▼

Yes, you can modify existing spreadsheets while preserving formulas by using openpyxl to execute formula-aware workflows, ensuring cached recalculation and data integrity are maintained during edits.

What file formats are supported for spreadsheet automation and analysis?▼

Spreadsheet automation supports .xlsx, .csv, and .tsv file formats, allowing you to create, edit, and analyze tabular data seamlessly using pandas and openpyxl libraries.

Does openpyxl support creating charts and visualizing tabular data?▼

Yes, openpyxl supports creating charts and visualizing tabular data, enabling you to format sheets and generate clear visual representations of your data analysis results.

What's the best way to analyze tabular data and calculate aggregations in Python?▼

The best way to analyze tabular data and calculate aggregations is using pandas for data manipulation combined with openpyxl for formula-aware workflows and cached recalculation in spreadsheet files.

How do you handle cached recalculation when automating spreadsheet workflows?▼

Handle cached recalculation in spreadsheet automation by leveraging openpyxl's formula-aware workflows, which preserve existing formulas and ensure correct value updates when modifying workbook data.

Related Skills

Explore More Data & Analytics Skills→
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced
bmadiganbmadigan
1

xlsx

Create, edit, and analyze Excel workbooks with openpyxl and pandas.

Community
Intermediate
patriotnewsactivismpatriotnewsactivism
2

excel-generator

Generate Excel spreadsheets with formatting, formulas, charts, and data validation.

Community
Advanced
vinayakgvinayakg

xlsx

Create and edit Excel files with formulas, formatting, and pandas analysis.

Community
Advanced