xlsx-editor

What problem does it solve?

Modifying existing Excel files often leads to broken formulas, lost formatting, or data inconsistencies, especially in complex, multi-tab workbooks. This Skill ensures all changes are made safely and correctly, preserving the integrity of your spreadsheets.

Core Features & Use Cases

• Integrity-Preserving Edits: Safely update cell values, add rows/columns, and manage multi-tab data without breaking formula dependencies or formatting.
• Mandatory Pre-Edit Analysis: Automatically analyzes sheet structures, formula dependencies, sort orders, and merged cells before any modifications to prevent errors.
• Multi-Tab Consistency: Ensures that data appearing across multiple sheets is updated completely and consistently, preventing critical data inconsistencies.
• Post-Edit Validation: Provides a comprehensive checklist to verify formula integrity, structural consistency, sort order, and formatting after all changes are applied.
• Use Case: You need to add a new row of sales data to 'Q3_Report.xlsx' on the 'Sales' tab. This skill will ensure the new row is inserted in the correct chronological sort order, with matching formatting, and that any summary formulas referencing the range are updated correctly across all related tabs.

Quick Start

I need to add a new row of sales data for '2024-06-15, Sales, 1500' to 'Q3_Report.xlsx' on the 'Data' tab, ensuring it maintains the correct chronological sort order and formatting.