skills.rest
DEEP-PolyU
DEEP-PolyUOFFICIAL
Explore all skills by this author →
WebsiteGitHub

spreadsheet

Automate spreadsheet creation, editing, and analysis with formula preservation.

1|Updated Apr 9, 2026
Search Tags:#visualization#pandas#openpyxl#formulas#spreadsheet#data-analysis
One-click install
npx skills add https://github.com/DEEP-PolyU/matopt-xlab --skill spreadsheet-deep-polyu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet
Source: https://github.com/DEEP-PolyU/matopt-xlab/tree/main/backend/skills/spreadsheet
Command: npx skills add https://github.com/DEEP-PolyU/matopt-xlab --skill spreadsheet-deep-polyu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Spreadsheet tasks often involve repetitive creation, editing, and formatting while preserving complex formulas and references. This Skill helps you automate these workflows while keeping workbook structure stable and reproducible.

Core Features & Use Cases

  • Formula-aware workbook creation and editing using OpenPyXL
  • Data analysis and reporting with pandas and CSV/Excel support
  • Safe recalculation, layout preservation, and visual checks for charts and styling
  • Use Case: Build a workbook from CSV data, apply formatting, and generate a summary sheet

Quick Start

Run the spreadsheet skill to generate a sample workbook and verify that formulas are preserved and formatting remains intact.

Frequently Asked Questions about spreadsheet

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

FAQPage Schema
How do I automate Excel editing while preserving existing formulas and formatting?▼

Automate Excel editing with formula-aware workflows that use OpenPyXL to preserve formulas, references, and layout. The spreadsheet skill ensures workbook structure remains stable and reproducible during automated creation and editing tasks.

Can I build a formatted workbook directly from CSV or TSV data?▼

Build a formatted workbook directly from CSV or TSV data using pandas for analysis and OpenPyXL for formatting. The spreadsheet skill supports importing these formats to generate structured Excel files with applied styling and summary sheets.

Does this approach support data visualization and chart generation within Excel files?▼

Data visualization and chart generation within Excel files are supported through safe recalculation and visual checks. The spreadsheet skill provides optional rendering steps to ensure charts and styling remain consistent in outputs.

What is the best way to clean and analyze spreadsheet data across development and production environments?▼

Clean and analyze spreadsheet data across development and production environments using pandas and OpenPyXL. The spreadsheet skill enforces formula preservation and provides validation steps to ensure consistent outputs for data analysis and reporting.

Are there limitations when recalculating formulas or preserving workbook layout in automated workflows?▼

Formula recalculation and layout preservation limitations are mitigated through safe formatting enforcement and optional validation steps. The spreadsheet skill uses OpenPyXL to maintain workbook structure stability and prevent reference corruption during automated processing.

Related Skills

Explore More Data & Analytics Skills→
spandiosspandios

spreadsheet

Create, edit, and analyze .xlsx, .csv, and .tsv spreadsheet files.

Community
Intermediate
UNO998UNO998

xlsx

Create, edit, and transform Excel workbooks with formulas and formatting.

Community
Advanced
MunreaderMunreader

xlsx

Create and edit Excel spreadsheets with formulas, charts, and data analysis.

Community
Intermediate
AutumnsGroveAutumnsGrove
26

xlsx

Automates Excel workbook creation, editing, and analysis via OpenPyXL and Pandas.

Community
Intermediate