xlsx-editor

Name: xlsx-editor
Availability: InStock
Author: kwoekel

Edit Excel workbooks while preserving formulas, formatting, and multi-tab integrity.

Updated Apr 11, 2026

Search Tags:#data integrity #Excel #formula preservation #workbook editing #multi-tab integrity

Ready to run

npx skills add https://github.com/kwoekel/Jones --skill xlsx-editor-kwoekel

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: xlsx-editor
Source: https://github.com/kwoekel/Jones/tree/main/skills/xlsx-editor
Command: npx skills add https://github.com/kwoekel/Jones --skill xlsx-editor-kwoekel

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill ensures the preservation of formulas, formatting, and structure in Excel workbooks during editing, especially in complex, multi-tab environments.

Core Features & Use Cases

Formula Preservation: Safely update cell values without breaking formula dependencies.
Formatting Consistency: Keep formatting, merged cells, and conditional formatting intact.
Multi-Tab Integrity: Update all related tabs consistently, maintaining data integrity.
Use Case: Ideal for financial analysts or data scientists who need to modify large Excel files with multiple sheets and complex formulas without disrupting the workbook's structure.

Quick Start

Use the xlsx-editor skill to update the value in cell A5 of the workbook 'financial_data.xlsx' to '2024-01-01'.

Frequently Asked Questions about xlsx-editor

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

FAQPage Schema

How do I edit an Excel workbook without breaking existing formulas?▼

To edit an Excel workbook without breaking formulas, you need a method that preserves formula dependencies while updating cell values. This approach ensures formula integrity is maintained across all modified cells.

Can I update cell values in a multi-tab Excel file and keep formatting intact?▼

You can update cell values in a multi-tab Excel file while keeping formatting intact by using openpyxl for workbook manipulation. This process preserves merged cells, conditional formatting, and multi-tab integrity during edits.

Does openpyxl support inserting rows and columns while preserving workbook structure?▼

Openpyxl supports inserting rows and columns while preserving workbook structure by managing workbook edits that maintain formatting and multi-tab integrity. This allows consistent structure updates across related sheets.

What is the best way to modify large Excel files with multiple sheets and complex formulas?▼

The best way to modify large Excel files with multiple sheets and complex formulas is to use a solution combining openpyxl and pandas. This ensures data analysis and workbook manipulation maintain structural consistency.

How do I update formulas across multiple Excel sheets consistently?▼

To update formulas across multiple Excel sheets consistently, use a workbook editing method that enforces multi-tab integrity. This ensures all related tabs are updated without disrupting the overall workbook structure.