跳转到主要内容
此内容尚未提供您的语言版本,正在以英文显示。

AlterLab XLSX

技能 活跃

Part of the AlterLab Academic Skills suite. Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

目的

To provide a specialized tool for any task involving spreadsheet files as primary input or output, ensuring dynamic and error-free Excel deliverables.

功能

  • Edit, read, and fix existing spreadsheet files (.xlsx, .xlsm, .csv, .tsv)
  • Add columns, compute formulas, format, chart, and clean messy data
  • Create new spreadsheets from scratch or other data sources
  • Convert between tabular file formats
  • Recalculate formulas and verify error-free deliverables
  • Clean and restructure messy tabular data files

使用场景

  • Use when needing to add columns or compute formulas in an existing .xlsx file.
  • Use when requiring data cleaning or formatting for .csv or .tsv files.
  • Use when creating new spreadsheets from scratch or converting data between formats.
  • Use when needing to fix formula errors in an Excel model.

非目标

  • Do NOT trigger when the primary deliverable is a Word document.
  • Do NOT trigger when the primary deliverable is an HTML report.
  • Do NOT trigger when the primary deliverable is a standalone Python script.
  • Do NOT trigger when the primary deliverable is a database pipeline.
  • Do NOT trigger when the primary deliverable is a Google Sheets API integration.

工作流

  1. Load or create the Excel file using pandas or openpyxl.
  2. Modify data, formulas, and formatting as required.
  3. Save the modified Excel file.
  4. Recalculate all formulas using the `scripts/recalc.py` script.
  5. Verify and fix any identified formula errors before finalizing.

Execution

  • warning:Pinned dependenciesThe skill relies on external libraries like pandas and openpyxl, but there is no explicit mention of pinned dependencies or lockfiles in the documentation, which could lead to compatibility issues.
  • warning:Pinned dependenciesThe skill relies on Python libraries (pandas, openpyxl) and LibreOffice, but there is no mention of pinned versions or lockfiles, potentially leading to compatibility issues with future updates.

Trust

  • info:Issues AttentionThe repository has 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity, but the total count is small.
  • info:Issues AttentionThere are 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity, but the overall issue count is small.
  • info:Issues AttentionThere are 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity but a small total count.

Maintenance

  • warning:Dependency ManagementWhile the skill uses standard Python libraries and LibreOffice, there's no explicit mention of dependency pinning or lockfiles, which could lead to version conflicts.

安装

npx skills add AlterLab-IEU/AlterLab-Academic-Skills

通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。

质量评分

90 /100
1 day ago 分析

信任信号

最近提交17 days ago
星标15
许可证MIT
状态
查看源代码

类似扩展

XLSX Skill

96

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.

技能
SeifBenayed

Lark Cli sheets

92

飞书电子表格:创建和操作电子表格。支持创建表格、创建/复制/删除/更新工作表、读写单元格、追加行数据、查找内容、导出文件。当用户需要创建电子表格、管理工作表、批量读写数据、在已知表格中查找内容、导出或下载表格时使用。若用户是想按名称或关键词搜索云空间里的表格文件,请改用 lark-doc 的 docs +search 先定位资源。

技能
larksuite

Xlsx Processing Openai

85

Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. Use to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing tabular data, (3) Modifying existing spreadsheets while preserving formulas, (4) Building financial models with proper formatting, (5) Data visualization with in-sheet charts, or any other spreadsheet tasks.

技能
lawvable

Embedding Strategies

100

Select and optimize embedding models for semantic search and RAG applications. Use when choosing embedding models, implementing chunking strategies, or optimizing embedding quality for specific domains.

技能
wshobson

Aws Cdk Development

100

AWS Cloud Development Kit (CDK) 专家,用于使用 TypeScript/Python 构建云基础设施。在创建 CDK 堆栈、定义 CDK 构造、实现基础设施即代码,或当用户提及 CDK、CloudFormation、IaC、cdk synth、cdk deploy,或希望以编程方式定义 AWS 基础设施时使用。涵盖 CDK 应用结构、构造模式、堆栈组合和部署工作流。

技能
zxkane

Fit Drift Diffusion Model

100

Fit cognitive drift-diffusion models (Ratcliff DDM) to reaction time and accuracy data with parameter estimation (drift rate, boundary separation, non-decision time), model comparison, and parameter recovery validation. Use when modeling binary decision-making with reaction time data, estimating cognitive parameters from experimental data, comparing sequential sampling model variants, or decomposing speed-accuracy tradeoff effects into latent cognitive components.

技能
pjt222