Skip to content
cccskills
FreePublished on GitHub

et-excel

ET Excel MCP workflow for reading, writing, styling, transforming, and inspecting xlsx data. Use when operating Excel cells, ranges, sheets, formulas, charts, merges, batch data import/export, or editing Luban source spreadsheets before export.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931 stars(GitHub 931 + cccskills 0)
Works withExcel

Run score Not tested

See how to install

Files included (5)

  • SKILL.md3.4 KB
  • references.meta172 B
  • references/et-excel-cli.md6.1 KB
  • references/et-excel-cli.md.meta158 B
  • SKILL.md.meta158 B

SKILL.md (original)

Review the instructions the agent will receive before you install.

et-excel - ET Excel 入口

强制规则(重要)

  • 只要涉及 Excel/xlsx 的任何读写操作,都必须调用 excelmcp(ET.ExcelMcp)完成;禁止手写脚本或用其它库/工具直接改 xlsx。

  • excelmcp 源工程位置:./Packages/cn.etetet.config/DotNet~/ET.ExcelMcp。

  • 运行入口(编译产物):仓库根目录 ./Bin/ET.ExcelMcp.dll,统一在仓库根用 dotnet ./Bin/ET.ExcelMcp.dll ... 调用。

  • 若 ./Bin/ET.ExcelMcp.dll 不存在(没有可执行文件),先编译工程再操作:

    dotnet build "./Packages/cn.etetet.config/DotNet~/ET.ExcelMcp/ET.ExcelMcp.csproj" -c Debug
    

    产物会输出到 ./Bin/ET.ExcelMcp.dll(csproj 的 OutputPath = $(RepoRoot)Bin,RepoRoot 即仓库根)。

何时使用

  • 通过 Bin/ET.ExcelMcp.dll 读写 Excel
  • 处理单元格、区域、样式、公式、图表、工作表
  • 做批量数据导入导出、筛选、排序、合并单元格
  • 维护 Luban 配置表内容,但还没有进入导出阶段

不要加载

  • 只是编译、跑测试、做 Unity 编辑器操作
  • 只是执行 Luban 导出,不需要实际读写 Excel(用 et-luban)
  • 只是讨论表结构,不需要实际读写 Excel

默认动作

  1. 先 cli list 或 cli help <工具名>,不要硬背完整工具表。
  2. 能批量就批量,优先 excel_range / excel_data_operations,不要逐格操作。
  3. JSON 参数只传本次调用最小字段集;pwsh 中优先外层单引号。
  4. 写操作优先使用绝对路径;覆盖原文件前先确认目标文件。
  5. 维护 Luban __beans__/__enums__/多态数据表时:用 excel_data_operations batch_write 只写非空格(空行真空);写完必须 excel_merge_cells merge 合并"列表"表头(*fields J1:P1、*items H1:L1、多态字段表头跨子列宽),否则 Luban 导出报缺 alias 列;含中文走 Write→UTF-8 Python→ExcelMcp,读回校验合并用 get_merged、文本用 ascii()。完整格式见 et-luban。
  6. 改完表如果需要生成配置产物,再叠加 et-luban。

配置约定(项目规范)

  • 资源类字段只填资源名:不写完整路径与后缀;表里若出现 Assets/.../xxx.prefab 这类完整路径,应收敛为 xxx(加载侧按名字 LoadAsset)。
  • 新增配置表必须注册 __tables__.xlsx:补全 Category / value_type / input / index / group,否则 Luban 导不到这张表。
  • 改完表必须导出,且优先定向导出:只导受影响的配置数据/代码(如对应 GameConfig 的 s / c / cs),避免全量导出超时;导出与导出后 Unity 刷新走 et-luban。
  • 写中文必须二次验证:读回或检查 xlsx 的 sharedStrings.xml,不要只信终端输出(详见 references/et-excel-cli.md 的「中文写入防乱码」)。

优先入口

  • dotnet ./Bin/ET.ExcelMcp.dll cli list
  • dotnet ./Bin/ET.ExcelMcp.dll cli help <工具名>
  • dotnet ./Bin/ET.ExcelMcp.dll cli <工具名> '<JSON参数>'

按需补读

  • references/et-excel-cli.md:工具选择、pwsh JSON 传参、常用示例

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Unity Editor and Player Runtime CLI integration for AIBridge. Use when Codex needs to compile Unity, inspect Console logs, search/read assets, manipulate GameObjects, Transforms, components, SerializedProperty values, scenes, screenshots/GIFs, connect to built Player runtime targets, simulate Play Mode runtime input, editor focus/menu items/game view, or look up AIBridgeCLI command syntax. For batch/multi scripts use aibridge-batch-script. For complex prefab asset edits use aibridge-prefab-patch. For unsupported direct Unity YAML serialized asset edits use unity-yaml-editing.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

AIBridge batch and multi command automation. Use when Codex needs to run multiple Unity Editor CLI operations together, write batch scripts, use multi --cmd or multi --stdin, handle call/delay/log/menu lines, avoid PowerShell quoting issues, or automate long/JSON-heavy AIBridgeCLI workflows.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

Optional read-only AIBridge Code Index semantic lookup for Unity projects. Use only when this Skill is installed and project rules or AIBridge settings say Code Index is enabled. Use for CLI-only symbol, definition, reference, implementation, derived-type, caller, and diagnostic queries. Do not use when Code Index is disabled; use rg, host file reads, and regular AIBridge commands instead.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

AIBridge/Unity 项目的标准开发工作流。Use when creating, modifying, fixing, refactoring, or validating C# code, Unity assets, prefabs, editor tools, package structure, tests, AGENTS.md, or local Skills. Preserves visible modes for Skills matching, requirement confirmation, analysis, implementation, and final checklist. Do not use for pure Q&A, simple search/display, or code explanation tasks with no file/code/asset changes.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

Unity Prefab asset patch workflow for AIBridge. Use when modifying complex prefab assets with prefab patch operations, child or component creation, SerializedProperty writes, array edits, internal GameObject/component references, dry-run validation, or when deciding between prefab patch, inspector set_property, scene object commands, and direct Unity YAML fallback.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

ET async and EntityRef safety workflow. Use when adding, modifying, or reviewing async/await, ETTask, generic ETTask results, ETCancellationToken, NewContext, concurrent waits, handler Run async safety, or any Entity access after await in WOW/ET code or tests.

The English summary is being prepared. Showing the original description.

FlameskyDexive/Legends-Of-Heroes931Updated Sep 22, 2026

See all skills by FlameskyDexive

Report a problem with this skill