xlsx

Generate, edit, and analyze spreadsheet workbooks with Excel formulas and validation.

9|2|Updated Apr 24, 2026
One-click install
npx skills add https://github.com/TasiTech/tasi-harness --skill xlsx-tasitech
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/TasiTech/tasi-harness/tree/main/resources/skills/work/xlsx
Command: npx skills add https://github.com/TasiTech/tasi-harness --skill xlsx-tasitech

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you generate, edit, and analyze spreadsheet files while preserving correctness by preventing common Excel formula failures and validating workbook structure before delivery.

Core Features & Use Cases

  • Formula-safe spreadsheet creation and editing: Build new .xlsx/.xlsm/.csv/.tsv spreadsheets or update existing workbooks without hardcoding computed values and while preserving existing templates and formatting conventions.
  • Data analysis and visualization workflows: Use pandas for analysis steps and then write back structured results into spreadsheets, keeping calculations dynamic in Excel.
  • Recalculation and openability validation: Recalculate all formulas via LibreOffice and scan the workbook for Excel error states, then validate the produced XLSX package (parts, XML well-formedness, relationships, shared strings, styles, media signatures).

Quick Start

Ask the xlsx skill to create an Excel model for your uploaded dataset using formulas only, then validate the workbook and recalculate until it reports zero Excel formula errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I create an Excel model using formulas instead of hardcoded values?

To create an Excel model with formulas, you generate .xlsx or .xlsm spreadsheets using Excel formulas directly rather than Python hardcoding computed values. This ensures all calculations remain dynamic and editable within the workbook.

How do I edit an existing spreadsheet template without breaking styles?

You can edit an existing spreadsheet template without breaking styles by modifying the workbook while preserving its formatting conventions. This prevents packaging issues and maintains the original layout during updates.

Why do my spreadsheet formulas show errors after writing data with pandas?

Spreadsheet formulas show errors after writing data with pandas because computed values are often hardcoded or not recalculated. You must recalculate formulas using a LibreOffice-based script to update outputs and ensure zero detected Excel error strings.

How do I validate an XLSX file for XML well-formedness and packaging errors?

You validate an XLSX file for packaging errors by running a validation node script that scans the workbook structure. This checks parts, XML well-formedness, relationships, shared strings, styles, and media signatures.

Does this spreadsheet generation workflow support data analysis and visualization?

Yes, the spreadsheet generation workflow supports data analysis and visualization by using pandas for analysis steps. It then writes structured results back into spreadsheets while keeping calculations dynamic in Excel.

What is the best way to update existing .xlsm files without causing formula recalculation failures?

The best way to update .xlsm files without formula recalculation failures is to modify the workbook using openpyxl while maintaining Excel formulas, then recalculate with a LibreOffice-based script to verify zero error states.