skills.rest
ZJU-REAL
ZJU-REALOFFICIAL
Explore all skills by this author →
GitHub

excel-editing

Create, edit, validate, and convert Excel workbooks into XLSX deliverables.

195|12|Updated Jul 19, 2026
Search Tags:#financial modeling#spreadsheet#excel#chart generation#xlsx#formula validation#workbook editing
One-click install
npx skills add https://github.com/ZJU-REAL/HugAgentOS --skill excel-editing
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-editing
Source: https://github.com/ZJU-REAL/HugAgentOS/tree/main/src/backend/skill_bundles/default/excel-editing
Command: npx skills add https://github.com/ZJU-REAL/HugAgentOS --skill excel-editing

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill eliminates the repetitive and error-prone work of creating, editing, validating, and converting Excel workbooks while ensuring that the requested XLSX file is produced and delivered correctly.

Core Features & Use Cases

  • Workbook Creation: Build formatted data tables and formula-driven financial or analytical models with headers, column widths, frozen panes, role-based styling, and live formulas.
  • Workbook Editing: Update cells and formulas, insert rows, add calculated columns, rename sheets, add worksheets, and insert native charts while preserving advanced workbook features when possible.
  • Validation and Conversion: Inspect workbook structure, read sheet data, validate formulas and references, save finalized workbook names, and convert completed XLSX files to PDF.
  • Use Case: Turn a quarterly revenue dataset into a polished workbook with calculated profit margins, summary totals, a native chart, formula validation, and an optional PDF export.

Quick Start

Use the Excel editing skill to create a formatted workbook from the supplied revenue data with live formulas and a summary chart.

Frequently Asked Questions about excel-editing

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

FAQPage Schema
How do I create an Excel workbook with live formulas and a summary chart?▼

To create an Excel workbook with live formulas and a summary chart, you can build formatted data tables, apply calculated columns, insert native charts, and validate formulas to ensure the XLSX deliverable is structured correctly.

Can I edit an existing XLSX file and add new calculated columns without breaking advanced workbook features?▼

Yes, you can update cells, insert rows, add calculated columns, rename sheets, and insert charts while performing preservation-aware editing to maintain advanced workbook features within the XLSX file.

What is the best way to validate formulas and references in a financial modeling spreadsheet?▼

The best way to validate formulas and references in a financial modeling spreadsheet is to inspect the workbook structure, read sheet data, and apply formula validation to ensure calculation accuracy before finalizing the file.

Do I need LibreOffice and openpyxl to convert an XLSX file to PDF?▼

Yes, converting an XLSX file to PDF requires the excel-cli workflow with openpyxl and LibreOffice support to execute structured workbook operations and produce the final PDF document output.

Does openpyxl support inserting native charts and frozen panes during workbook creation?▼

Yes, using openpyxl support, you can build formatted data tables with headers, frozen panes, role-based styling, and insert native charts during the creation and editing of Excel workbooks.

Why does my spreadsheet formula return an error after updating rows in an existing workbook?▼

Spreadsheet formula errors after updating rows often occur when references are broken; use formula validation and workbook inspection to check cell references and ensure preservation-aware editing maintains calculation integrity.

Related Skills

Explore More Finance & Accounting Skills→
RheasilviaRheasilvia

excel-author

Generate auditable .xlsx financial workbooks with openpyxl and banker-grade conventions.

Community
Advanced
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced
trungdo9trungdo9
3

xlsx

Create, edit, and analyze .xlsx files with Python and openpyxl.

Community
Advanced
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate