Excel Spreadsheet Operations
Skill ПопередженняComprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
It leverages Python libraries like pandas and openpyxl for data manipulation and formatting, and includes a utility script for recalculating Excel formulas. The skill emphasizes using Excel formulas over hardcoded values to maintain dynamic spreadsheets.
Documentation
- info:Configuration & parameter referenceWhile parameters for libraries like pandas and openpyxl are implicitly documented by their usage, there is no explicit documentation for any skill-specific configurations or environment variables that might be used. The reliance on LibreOffice for recalculation is mentioned but not detailed as a configurable parameter.
License
- critical:License usabilityThe extension is licensed as 'Proprietary' with 'Use of these materials is governed by your agreement with Anthropic' and includes significant restrictions such as prohibiting copies outside the Services, creating derivative works, and distributing the materials. This license is not a standard open-source or commercially usable license.
Versioning
- warning:Release ManagementNo version information (e.g., version field in manifest, git tags, CHANGELOG) is present for this skill. Installation would likely rely on a specific commit or branch, making version pinning difficult.
Code Execution
- warning:ValidationWhile the Python scripts use pandas and openpyxl, there's no explicit mention or implementation of schema validation libraries for input arguments (like file paths or script parameters) beyond basic file existence checks. The `recalc.py` script's output is JSON, but internal validation of LibreOffice's execution or macro setup isn't deeply detailed.
- warning:LoggingThere is no explicit logging mechanism to an audit file for actions taken by the skill, such as file modifications or formula recalculations.
- warning:Tool FallbackThe skill explicitly requires LibreOffice for formula recalculation via `recalc.py` and does not list this dependency or a fallback in the frontmatter. While the script attempts setup, its absence is a potential failure point not clearly communicated as optional.
Portability
- warning:Runtime stabilityThe skill explicitly requires LibreOffice for formula recalculation, which is a significant external dependency that may not be available in all runtime environments. While the script attempts to set it up, it introduces a potential point of failure if setup fails or LibreOffice is not compatible.
Встановлення
npx skills add answerzhao/agent-skillsЗапускає Vercel skills CLI (skills.sh) через npx — потребує локально встановленого Node.js та принаймні одного агента, сумісного зі skills (Claude Code, Cursor, Codex, …). Передбачається, що репозиторій відповідає формату agentskills.io.
Подібні розширення
XLSX Spreadsheet Manipulator
40Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
XLSX Spreadsheet Skill
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.
XLSX Manipulation Skill
75Create, edit, and manipulate Excel spreadsheets programmatically using openpyxl
XLSX Generator
98Create and manipulate Excel XLSX files programmatically. Use when the user needs to generate spreadsheets, modify XLSX templates, extract spreadsheet content, or automate Excel workflows. Supports both template-based generation (for branding compliance) and from-scratch creation. Keywords: Excel, XLSX, spreadsheet, workbook, worksheet, data, report, template, financial, analysis.
Data Analysis Assistant
98Analyze spreadsheet data, generate insights, create visualizations, and build reports from Excel/CSV data.
Data Analysis Skill
96Use this skill when the user uploads Excel (.xlsx/.xls) or CSV files and wants to perform data analysis, generate statistics, create summaries, pivot tables, SQL queries, or any form of structured data exploration. Supports multi-sheet Excel workbooks, aggregation, filtering, joins, and exporting results to CSV/JSON/Markdown.