xlsx

Create, edit, and validate Excel spreadsheets with Python and LibreOffice.

26|12|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/insmtx/Lework --skill xlsx-insmtx
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/insmtx/Lework/tree/main/backend/skills/worker/xlsx
Command: npx skills add https://github.com/insmtx/Lework --skill xlsx-insmtx

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Manual spreadsheet creation and editing is tedious and error-prone, especially when maintaining formula integrity, professional formatting, and data accuracy across complex workbooks. This Skill transforms Excel automation into a reliable, repeatable process that handles everything from simple data entry to sophisticated financial modeling.

Core Features & Use Cases

  • Formula-Centric Workflows: Creates and modifies Excel files using native formulas instead of hardcoded values, with mandatory LibreOffice recalculation and error scanning to guarantee zero #REF!, #DIV/0!, or #VALUE! errors.
  • Financial Modeling Standards: Enforces industry-standard color coding, number formatting, and assumption documentation for revenue models, valuation analyses, and budget forecasts.
  • Data Pipeline Integration: Reads messy CSV/TSV files, cleans malformed rows, and converts between tabular formats using pandas, then outputs polished, professional spreadsheets.
  • Document Validation: Includes a full Office document validation engine that checks XML schemas, relationship integrity, and tracked changes for DOCX, PPTX, and XLSX files.

Quick Start

Use the xlsx skill to open the attached 'sales_forecast.xlsx' file, update the growth rate assumptions in the hidden 'Inputs' sheet with the latest market data, recalculate all dependent formulas, and return the validated workbook ready for executive review.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I automate Excel creation and editing while preserving native formulas?

Automate Excel creation and editing by using openpyxl to manage native formulas instead of hardcoded values. The skill enforces mandatory LibreOffice recalculation and error scanning to guarantee zero #REF!, #DIV/0!, or #VALUE! errors in the generated .xlsx workbook.

Can I use Python to clean messy CSV files and output a formatted Excel spreadsheet?

Yes, you can use Python with pandas to read messy CSV or TSV files and clean malformed rows. The skill then converts the cleaned tabular data into polished, professional .xlsx spreadsheets with proper formatting for downstream financial reporting.

Does this Excel automation approach support financial modeling standards and formatting?

This Excel automation approach supports financial modeling by enforcing industry-standard color coding, number formatting, and assumption documentation for revenue models, valuation analyses, and budget forecasts within the generated .xlsx files.

How do I validate an Office document for XML schema and relationship integrity errors?

Validate an Office document using the built-in validation engine that checks XML schemas, relationship integrity, and tracked changes for DOCX, PPTX, and XLSX files. This ensures structural correctness and detects corruption before document distribution.

Do I need LibreOffice to recalculate formulas and scan for errors in openpyxl workflows?

Yes, you need LibreOffice to recalculate formulas and scan for errors in openpyxl workflows. The skill requires LibreOffice for mandatory recalculation to guarantee that all dependent formulas evaluate correctly without producing hidden calculation errors.

What is the best way to convert tabular data between .xlsx, .xlsm, .csv, and .tsv formats?

The best way to convert tabular data between .xlsx, .xlsm, .csv, and .tsv formats is using pandas for data manipulation and openpyxl for formula management. This combination ensures data integrity is maintained across format conversions.