Skill Claude CodeCodex
Scan all date columns in Excel and convert datetime values to user-specified text format (yyyymmdd, yyyy-mm-dd, yyyy/mm/dd, yyyy年mm月dd日, or any custom combination). Supports three output positions: insert new column on left, insert new column on right, or replace original column. New column headers can be customized…
Skill Claude CodeCodex
Deduplicate Excel data by key column — keep first occurrence, delete subsequent duplicates. First calls excel-find-duplicates for read-only scanning to find duplicate row numbers, then confirms and deletes via XML direct ops (bypassing openpyxl, 10x faster). Format fully preserved (only rows removed, kept rows…
Skill Claude CodeCodex
Safely delete rows or columns in Excel files. Auto-checks formula dependencies before deletion to prevent #REF! errors. Row deletion uses XML direct ops (10x faster), column deletion uses openpyxl. Supports by index, by name, and batch deletion. 在 Excel 文件中安全删除行或列。删除前自动检查公式依赖，防止产生 #REF! 错误。行删除使用 XML 直接操作（快 10 倍），列删除使用…
Skill Claude CodeCodex
Filter Excel data rows by condition — keep or delete rows matching criteria. First uses pandas read-only scan to identify target row numbers, then uses XML direct operations to remove unwanted rows (format-preserving). Supports equals, contains, range, date comparison, and other common filters. 按条件筛选 Excel…
Skill Claude CodeCodex
Read-only scan of Excel files to find duplicate rows by specified column(s), outputting duplicate row number lists. Does not modify the original file. Typically used in conjunction with excel-delete for safe, format-preserving deduplication. 只读扫描 Excel 文件，按指定列查找重复行，输出重复行号列表。不修改原文件。通常配合 excel-delete 使用实现安全的格式无损去重。…
Skill Claude CodeCodex
Uniformly adjust Excel file formatting — font, size, bold, italic, color, alignment (horizontal/vertical), column width, row height. Supports per-scope application: entire sheet, specified columns/rows, headers, data area, or condition-matched cells. 统一调整 Excel…
Skill Claude CodeCodex
Freeze or unfreeze Excel worksheet panes. Supports freeze top row, freeze first column, freeze top row + first column, freeze at specified position. 冻结或取消冻结 Excel 工作表窗格，支持冻结首行、冻结首列、冻结首行+首列、冻结指定位置。 Trigger keywords: "freeze" "freeze header" "lock top row" "freeze first column" "unfreeze"…
Skill Claude CodeCodex
A tool for inserting rows or columns into Excel spreadsheets. It can place them beside a chosen column or above or below a chosen row, with optional names and content.
Skill Claude CodeCodex
Batch replace column values by mapping table. User provides mapping relationships (spoken in conversation / pasted list / mapping file), and the skill auto-matches and replaces corresponding values in the target column. Values not in the mapping table are preserved as-is.…
Skill Claude CodeCodex
A tool for combining multiple Excel files with the same column structure into one file.
Skill Claude CodeCodex
Default entry point — all Excel file operations should consider this skill first. Auto-trigger Conditions (any one suffices) / 自动触发条件（满足任一即触发） Condition 1: User mentioned an Excel file / 条件一：用户提到了 Excel 文件 As long as an Excel file (.xlsx / .xlsm / .csv / .xls / spreadsheet / workbook / worksheet) appears in context…
Skill Claude CodeCodex
Use regular expressions to clean Excel column content — extract, delete, or replace matched portions. Supports three modes: extract (capture matched content), remove (delete matched content), replace (substitute matched content). XML fast path for large files (4x faster). 用正则表达式清理 Excel…
Skill Claude CodeCodex
Safely replace content in Excel — entire columns, rows, or condition-matched cells. Supports replacing with fixed values, Excel formulas, or Python transform functions. 安全替换 Excel 中的内容——整列、整行、或指定条件的单元格。支持替换为固定值、Excel 公式、或 Python 转换函数。 Trigger keywords: "replace column" "overwrite column" "entire column to" "replace…
Skill Claude CodeCodex
Excel safe editing five-step method (Backup→Scout→Plan→Execute→Verify). When users need to do structural editing on existing Excel files (insert columns, delete columns, modify data, format conversion, etc.), use this skill to ensure safe operations and avoid data corruption. Suitable for large files (>10MB or >10K…
Skill Claude CodeCodex
Pre-operation reconnaissance — read-only scan of Excel files to locate columns relevant to user needs, output a structured scout report for user confirmation. Makes no modifications. When users describe complex Excel operation needs but haven't specified column numbers/names/current values, use this skill first to…
Skill Claude CodeCodex
An Excel data-sorting tool that arranges rows by one or more columns. It supports ascending or descending order for numbers, dates, and text.
Skill Claude CodeCodex
Split a large table into multiple files by a specified column (one file per unique value). Uses pandas grouping + iterparse streaming fan-out (single XML parse, multi-output), with format fully preserved. Supports limiting split count (Top N + Others). 按指定列将一个大表拆分成多个文件（每个值一个文件）。用 pandas 分组 + iterparse…
Skill Claude CodeCodex
Read-only scan of Excel files to check data quality — null rate, outliers, format consistency, duplicate values, etc. Outputs a quality issue report without modifying the original file. 只读扫描 Excel 文件，检查数据质量——空值率、异常值、格式一致性、重复值等。输出质量问题报告，不修改原文件。 Trigger keywords: "check data" "validate" "null values" "data quality" "any…