xlsx-editor

This skill provides specialized workflows for editing existing Excel files while preserving their integrity. It addresses the unique challenges of modifying live workbooks: maintaining formula relationships across tabs, preserving formatting and structure, ensuring data insertion maintains sort order, and guaranteeing completeness of multi-tab updates.

Always Analyze Before Editing Never dive directly into making changes. First understand the file's structure, dependencies, and relationships.

Preserve, Don't Replace The existing file has established patterns. Maintain its structure, formulas, and formatting conventions rather than imposing new ones.

编辑现有 Excel 文件的专业指南，重点是跨多个选项卡保留公式、格式和结构。在修改、更新数据或向现有 .xlsx 文件添加数据时，可以使用此技能，在这些文件中保持完整性至关重要，特别是对于多选项卡工作簿、复杂公式、格式化表格以及必须保持排序顺序和跨工作表关系的数据。 来源：exploration-labs/nates-substack-skills。