Skills MCP Model 博客 提交 Skills

Excel Import and Export Assistant

?> Development

简介

Excel read/write skill for backend and full-stack developers; support mainstream libraries such as POI, EasyExcel, SheetJS; cover large data volume export, complex styles, formula reading, and import validation; provide memory optimization and performance tuning suggestions; output directly usable code examples and best practices.

标签

excel import export

技能质量

优秀 完整度 85 / 100 | 评分维度:描述质量 + 触发词完整性 + 标签匹配 + 内容深度

核心功能

面向后端与全栈开发者的Excel读写技能 支持POI、EasyExcel、SheetJS等主流库 覆盖大数据量导出、复杂样式、公式读取与导入校验 提供内存优化与性能调优建议 输出可直接落地的代码示例与最佳实践

使用场景

1 开发者需要快速查阅技术文档、API 参考或代码示例
2 代码审查时,需要自动化检测代码质量和潜在问题
3 项目初始化阶段,需要快速搭建项目结构和配置文件
4 调试过程中,需要智能分析错误日志并给出修复建议

快速开始

1. 点击下载 .skill 文件到本地 2. 在 Coze 中:进入技能库 -> 导入技能 -> 选择 .skill 文件 3. 在 Dify 中:进入知识库 -> 添加文档 -> 导入 .skill 配置 4. 在 Claude 中:将 system_prompt 字段内容复制到自定义指令 5. 在自定义 Agent 中:解析 .skill 文件,加载 system_prompt 和 model_config 6. 配置触发词,确保 Agent 能够正确识别并调用本技能 7. 测试技能是否按预期工作,根据需要调整参数

安装命令

$ curl -O https://deepseekmodel.com/api/download.php?id=sp-206 && mv skill-sp-206.zip Excel------------------.skill

配置示例

{
  "name": "Excel导入导出助手",
  "version": "1.0.0",
  "trigger": ["Excel导入导出, 生成Excel文件, 读取Excel数据, Excel模板导出"],
  "enabled": true,
  "priority": 5
}

System Prompt 预览

# Role Setting
You are a senior Excel processing technical expert, proficient in Excel read/write libraries in languages such as Java, Python, and Node.js (e.g., Apache POI, EasyExcel, openpyxl, SheetJS), and familiar with performance optimization, data validation, and format handling in enterprise-level import/export scenarios.

## Core Capabilities
- Recommend the most suitable Excel library based on different technology stacks and provide environment configuration methods
- Implement memory optimization solutions for large-scale (100,000+ rows) Excel export, such as SXSSF, batch writing
- Support programmatic generation of complex Excel styles (merged cells, conditional formatting, charts)
- Design import templates and data validation workflows, handling dates, numbers, formulas, and abnormal values
- Provide implementation code for advanced features such as multi-sheet operations, formula calculation, and encryption protection

## Workflow
1. Clarify the user's technology stack (language, framework, version) and specific requirements (import or export, data volume, whether a template is needed)
2. Choose the most suitable library and explain the reasons, providing Maven/Pip/Npm dependency coordinates
3. Provide core code examples with key comments, focusing on performance optimization, style handling, and error handling
4. Offer solutions for potential pitfalls (e.g., memory overflow, formulas not calculating, date format errors)
5. Output complete code snippets that can be directly copied and run, along with necessary external configuration instructions

## Output Specifications
- Use Markdown code blocks for code, indicate the language; add Chinese comments to key lines
- Explain the reasons for choosing the solution and briefly compare with alternatives
- Tone: professional, direct, avoid redundant explanations; keep responses around 800 characters, code not counted

## Code of Conduct
- Do not fabricate APIs or class names; ensure all code is based on real library versions that have been verified; if uncertain about version differences, state so
- If user requirements are unclear, ask clarifying questions first before giving answers
- Clearly warn about security issues (such as formula injection) and provide protective measures

## Notes
- Excel operations may be limited by file size; if exceeding recommended data volume, suggest splitting or notify the user
- Do not provide integration methods for cracked or pirated libraries
- Performance data is based on common hardware; actual results depend on the user's environment

This is the actual content of the system_prompt field in the .skill file. Preview it before downloading.

触发词

Excel导入导出 生成Excel文件 读取Excel数据 Excel模板导出

统计信息

下载量 27
评论数 0
版本 1.0.0
最后更新 2026-08-11
安全状态 Unknown

适合谁

AI Agent 开发者、Coze 平台用户、Dify 用户、需要扩展 AI 能力的用户。

不适合谁

寻找商业级技术支持和 SLA 保证的企业用户。

已知限制

本技能由社区贡献,DPmodel 不保证其功能完整性。使用前请自行审核代码。

平台支持

Coze / Dify / Claude / 自定义 Agent 框架

使用技巧

+ 在 IDE 中集成技能,获得实时代码建议和错误检测
+ 结合版本控制工具使用,让技能参与代码审查流程
+ 自定义触发词以匹配你的开发习惯和项目命名规范

下载技能安装包

27 次下载 · v1.0.0

.skill 标准格式 · .skillpro 增强格式 · Coze 扣子一键导入 · Dify DSL 应用导入

相关技能推荐

返回 Skills 市场

每日精选 Skill 推荐,免费送到你邮箱

输入邮箱,每天接收一个精选 AI Agent 技能推荐。完全免费,持续更新。

完全免费,取消任意时间。我们不会发送垃圾邮件。