skills.rest
dachent
dachentCOMMUNITY
Explore all skills by this author →
GitHub

xlsx-win

Automate Microsoft Excel COM operations on Windows using JSON job contracts.

18|1|Updated Mar 19, 2026
Search Tags:#automation#data validation#spreadsheet#excel#windows#power query
One-click install
npx skills add https://github.com/dachent/skills --skill xlsx-win
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx-win
Source: https://github.com/dachent/skills/tree/main/xlsx-win
Command: npx skills add https://github.com/dachent/skills --skill xlsx-win

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This skill solves the reliability and fidelity issues inherent in using non-native libraries to edit complex Excel workbooks, ensuring that macros, data models, and pivot tables remain intact while performing automated refreshes and calculations.

Core Features & Use Cases

  • Native Excel COM Automation: Drives real Microsoft Excel instances to perform accurate refreshes, recalculations, and validations.
  • Deterministic Routing: Automatically selects the safest tool (xlsxwriter, openpyxl, or Excel COM) based on workbook complexity and risk features.
  • Validation Contracts: Evaluates workbook invariants like row counts, sentinel values, and calculation modes to ensure data quality before downstream use.
  • Use Case: Use this skill to refresh a complex financial model with multiple Power Query connections and pivot tables, ensuring the final output is recalculated correctly by Excel before it is used in a management report.

Quick Start

Use the xlsx-win skill to run a job manifest that opens, refreshes, and saves the workbook located at C:\data\report.xlsx.

Frequently Asked Questions about xlsx-win

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

FAQPage Schema
How do I automate Excel workbook refreshes on Windows without breaking pivot tables?▼

Automating Excel workbook refreshes on Windows without breaking pivot tables requires native Excel COM automation to drive real Microsoft Excel instances, ensuring data models and pivot tables remain intact during recalculation.

Can I use openpyxl to refresh Power Query connections in a spreadsheet?▼

Using openpyxl to refresh Power Query connections in a spreadsheet risks corrupting complex data models; native Excel COM automation is required for high-fidelity workbook connection refreshes and safe recalculations.

Does Excel automation support validating spreadsheet data before generating reports?▼

Excel automation supports validating spreadsheet data before generating reports by evaluating workbook invariants like row counts, sentinel values, and calculation modes through validation contracts to ensure downstream data quality.

What is the best way to automate complex financial models with multiple data connections on Windows?▼

The best way to automate complex financial models with multiple data connections on Windows is using a versioned JSON job contract to drive native Excel COM automation, applying deterministic routing to select the safest editing tool based on workbook complexity.

Why do my Power Query connections get corrupted when editing workbooks with Python libraries?▼

Power Query connections get corrupted when editing workbooks with non-native Python libraries due to reliability and fidelity issues; libraries lack native Excel COM automation needed to preserve macros, data models, and pivot tables.

Related Skills

Explore More Finance & Accounting Skills→
Awannaphasch2016Awannaphasch2016

mcp-integration

Register MCP servers via .mcp.json and escalate configuration through CLAUDE.md and hooks.

Community
Advanced
AIDotNetAIDotNet
602

excel-processor

Read, write, format, and analyze Excel workbooks with Python and openpyxl.

Official
Intermediate
iOfficeAIiOfficeAI
31.8k

xlsx

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

Official
Advanced
danger-Englishdanger-English
2

xlsx

Read, edit, and create spreadsheet files using Python libraries.

Community
Advanced