skills.rest
pycode4micro
pycode4microCOMMUNITY
Explore all skills by this author →
GitHub

xlsx

Create and repair Excel spreadsheets with formula recalculation and error scanning.

1|Updated Mar 6, 2026
Search Tags:#xlsx#data conversion#formula recalculation#excel formulas#spreadsheet modeling#error-free deliverables#financial workbook
One-click install
npx skills add https://github.com/pycode4micro/bushserver --skill xlsx-pycode4micro
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/pycode4micro/bushserver/tree/main/src/bushserver/seeds/skills/package/xlsx
Command: npx skills add https://github.com/pycode4micro/bushserver --skill xlsx-pycode4micro

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill helps you create, repair, and transform spreadsheet deliverables without breaking formulas or formatting, ensuring the final output remains a spreadsheet file.

Core Features & Use Cases

  • Spreadsheet deliverable handling: Opens, reads, edits, fixes, and creates .xlsx, .xlsm, .csv, and .tsv outputs.
  • Dynamic Excel modeling: Builds reusable workbooks with formulas (no hardcoded calculated values) and ensures spreadsheet integrity.
  • Formula recalculation & validation: Recalculates Excel formulas via LibreOffice and scans for Excel error values to guarantee zero formula errors.
  • Use case: You need a financial or operations spreadsheet that includes multiple tabs, pivot-style summaries, and validated formulas; deliver a corrected .xlsx that recalculates cleanly and contains no #REF!, #DIV/0!, #VALUE!, #NAME?, or #N/A style issues.

Quick Start

Use the xlsx skill to generate a corrected Excel workbook from the user-provided spreadsheet file so that all formulas recalculate with zero Excel errors.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I fix Excel formula errors like #REF! and #DIV/0! in my spreadsheet deliverables?▼

To fix Excel formula errors in spreadsheet deliverables, this Skill recalculates formulas via LibreOffice and scans for #REF!, #DIV/0!, #VALUE!, #NAME?, and #N/A values to guarantee zero formula errors in the output workbook.

How do I build a financial workbook with dynamic formulas instead of hardcoded calculated values?▼

Building a financial workbook with dynamic formulas requires generating reusable spreadsheet models without hardcoded calculated values, which this Skill enforces to ensure correct Excel behavior for dynamic updates and recalculations.

Can I convert CSV or TSV files into a formatted Excel workbook with pivot-style summaries?▼

Yes, you can convert CSV and TSV files into formatted Excel workbooks by generating multi-tab spreadsheets with pivot-style summaries and validated formulas while preserving correct dynamic Excel formatting.

What is the best way to repair a broken .xlsx file so that all formulas recalculate cleanly?▼

The best way to repair a broken .xlsx file is to process it through LibreOffice-based formula recalculation, which fixes the workbook structure and enforces zero Excel formula errors for clean dynamic updates.

Does this spreadsheet modeling approach support .xlsm macro-enabled workbooks?▼

Yes, this spreadsheet modeling approach supports .xlsm macro-enabled workbooks alongside .xlsx, .csv, and .tsv formats, allowing you to open, read, edit, fix, and create outputs while preserving spreadsheet integrity.

Why do my Excel formulas show calculation errors after converting from tabular input files?▼

Excel formulas show calculation errors after tabular input conversion when hardcoded calculated values break dynamic updates, which this Skill resolves by enforcing formula-based modeling and validating recalculation with zero errors.

Related Skills

Explore More Finance & Accounting Skills→
rangerrick337rangerrick337
10

xlsx

Automate Excel spreadsheet creation, editing, and analysis with formula integrity across .xlsx, .xlsm, .csv, and .tsv.

Community
Advanced
fantay0312fantay0312

xlsx

Create and edit Excel spreadsheets with formulas via LibreOffice recalculation.

Community
Advanced
eduardoabreu81eduardoabreu81
6

xlsx

Create and analyze XLSX workbooks with openpyxl, validating formulas and recalculations.

Community
Advanced
Zeyuyang-0420Zeyuyang-0420

xlsx

Create, edit, and analyze Excel files with pandas and openpyxl.

Community
Advanced