Xlsx
技能 警告 活跃Create, edit, analyze spreadsheets (.xlsx, .csv, .tsv). Use for Excel formulas, data analysis, visualization, formatting, pivot tables, charts, formula recalculation.
To provide a robust capability for users to interact with spreadsheet data, perform analysis, create dynamic financial models, and ensure formula integrity.
功能
- Create, edit, and analyze .xlsx, .csv, .tsv files
- Utilize pandas for data manipulation and analysis
- Employ openpyxl for complex formatting and formula creation
- Recalculate Excel formulas and identify errors with a dedicated script
- Apply industry-standard color-coding and number formatting rules
使用场景
- Analyzing data from downloaded CSV or XLSX reports
- Creating new financial models with dynamic formulas
- Editing existing spreadsheets to update data or formulas
- Ensuring spreadsheet formulas are error-free and correctly calculated
非目标
- Directly interacting with cloud-based spreadsheet services (e.g., Google Sheets, Office 365 online)
- Performing advanced visualization beyond what pandas or basic Excel charts can achieve
- Replacing dedicated desktop Excel software for highly complex or niche Excel features
License
- critical:License usabilityThe bundled LICENSE.txt file grants only limited usage rights, explicitly prohibits extraction, reproduction, distribution, and reverse engineering, and is not a standard OSI-approved open-source license, making it non-usable for redistribution.
Code Execution
- warning:ValidationWhile the skill mentions formula error prevention and interpretation of `recalc.py` output, there is no explicit mention or demonstration of using a schema library for input validation or sanitization of file paths or parameters passed to scripts.
- warning:Tool FallbackThe skill explicitly requires LibreOffice for formula recalculation via `recalc.py`, but does not specify how to install it or provide a fallback if it is not available, only stating it is 'required'.
Documentation
- info:READMEThe extension has a README.md, but it is for a Laravel project and completely unrelated to the spreadsheet skill, creating confusion.
Install
- warning:Installation instructionThe SKILL.md mentions LibreOffice is required for formula recalculation but does not provide clear installation steps or a verification method for it, relying on an assumption that it will be automatically configured on first run, which is not always reliable.
Execution
- info:Pinned dependenciesThe skill relies on standard Python libraries (pandas, openpyxl) which are typically installed via pip, but there is no explicit lockfile or version pinning declared for these dependencies within the skill's documentation.
安装
npx skills add binjuhor/shadcn-lar通过 npx 运行 Vercel skills CLI(skills.sh)— 需要本地安装 Node.js,以及至少一个兼容 skills 的智能体(Claude Code、Cursor、Codex 等)。前提是仓库遵循 agentskills.io 格式。
质量评分
警告类似扩展
XLSX Skill
96Use 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.
Xlsx Processing Openai
85Toolkit 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.
Spreadsheet Generation API
100Generate CSV, Markdown, and XLSX spreadsheets from structured tabular data.
Xlsx
75Use 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.
Fit Drift Diffusion Model
100Fit 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.
Generate Timesheet Export
99Generate an XLSX timesheet with logged hours, hourly rates, per-entry amount formulas, and totals for client billing or payroll.