skills.rest
pczhao1210
pczhao1210COMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create, edit, and validate spreadsheet files with formula recalculation via LibreOffice.

Updated Mar 6, 2026
Search Tags:#pandas#openpyxl#spreadsheet#excel#xlsx#recalculate#formula-validation
One-click install
npx skills add https://github.com/pczhao1210/reuseable-agents-and-skills --skill xlsx-pczhao1210
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/pczhao1210/reuseable-agents-and-skills/tree/main/.agents/skills/xlsx
Command: npx skills add https://github.com/pczhao1210/reuseable-agents-and-skills --skill xlsx-pczhao1210

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, defusedxml, lxml, and includes scripts (resource) components.

What problem does it solve?

Many tasks require accurate, editable spreadsheet deliverables but authors frequently struggle with messy tabular inputs, broken formulas, lost formatting, and non-recalculated models. This Skill centralizes best-practice workflows for creating, cleaning, editing, and converting .xlsx/.xlsm/.csv/.tsv files while enforcing formula-first design, preserving templates, and eliminating formula errors prior to delivery.

Core Features & Use Cases

  • Open / Read / Edit / Create: Load existing spreadsheets or build new workbooks with preserved formatting and templates.
  • Formula-first workflows: Insert Excel formulas (not hardcoded values), maintain consistent formatting, and verify recalculation results.
  • Recalculation & Validation: Recalculate formulas using the provided scripts/recalc.py with LibreOffice and scan for Excel errors (#REF!, #DIV/0!, #NAME?, etc.).
  • Data cleaning & conversion: Restructure malformed CSV/TSV data into clean worksheets, apply data types, and export between tabular formats.
  • Financial model conventions: Built-in guidance for assumption placement, color-coding, number formats, and documentation for hardcoded sources.
  • Use Case: Convert a messy CSV of transactions into a multi-sheet workbook with dynamic formulas, a assumptions sheet, formatted outputs, and a verified recalc report.

Quick Start

Open the file sales_report.xlsx, add an assumptions sheet with named assumption cells, compute projections using Excel formulas that reference those cells, run formulas recalculation, and return a validated output.xlsx file.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I convert a messy CSV file into a formatted Excel workbook with formulas?▼

To convert a messy CSV into a formatted Excel workbook, this Skill restructures malformed rows, applies data types, inserts dynamic formulas, and exports a validated .xlsx file. It enforces formula-first workflows to ensure calculations remain dynamic rather than hardcoded values.

Why does Excel show #REF! or #DIV/0! errors after editing an xlsx file programmatically?▼

Excel shows formula errors because programmatic edits often skip recalculation. This Skill validates xlsx files by recalculating formulas via LibreOffice and scanning for errors like #REF! and #DIV/0!, enforcing zero formula errors prior to delivery.

Does openpyxl support formula recalculation and validation for spreadsheet files?▼

While openpyxl handles file manipulation, this Skill uses LibreOffice via a dedicated recalculation script to validate formulas. It combines openpyxl, defusedxml, and lxml to enforce formula-first workflows and eliminate calculation errors in .xlsx and .xlsm files.

Can I preserve formatting and templates when editing an existing xlsx spreadsheet?▼

Yes, you can preserve formatting and templates when editing an existing xlsx spreadsheet. This Skill loads existing workbooks while maintaining consistent formatting, color-coding, and financial model conventions throughout the editing and formula insertion process.

What is the best way to clean malformed rows in a TSV or CSV file for Excel?▼

The best way to clean malformed rows in a TSV or CSV file is to restructure the data into clean worksheets, apply correct data types, and export between tabular formats. This Skill centralizes data cleaning workflows to prepare accurate spreadsheet deliverables.

How do I add an assumptions sheet with named cells for financial modeling in Excel?▼

To add an assumptions sheet with named cells, this Skill applies built-in financial model conventions for assumption placement, color-coding, and documentation of hardcoded sources. It ensures projection formulas correctly reference these named cells and pass recalculation validation.

Related Skills

Explore More Finance & Accounting Skills→
Gull-StackGull-Stack

xlsx

Create, edit, and analyze Excel spreadsheets with formulas using Python.

Official
Advanced
oimiragieooimiragieo
36

excel-generator

Generate multi-sheet Excel workbooks with formulas, charts, and formatting.

Community
Basic
AgentTeam-TaichuAIAgentTeam-TaichuAI
630

xlsx

Process and validate XLSX workbooks offline using openpyxl.

Community
Advanced
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

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

Official
Advanced