document-xlsx

Solid

Create/edit .xlsx spreadsheets with formulas, charts, and data validation. Use when asked to generate Excel reports, models, or exports.

Data & Documents 80 stars 17 forks Updated 1 weeks ago MIT

Install

Quality Score: 86/100

Stars 20%

64

Recency 20%

90

Frontmatter 20%

70

Documentation 15%

100

Issue Health 10%

80

License 10%

100

Description 5%

100

Skill Content

# Document XLSX Skill — Quick Reference This skill enables creation, editing, and analysis of Excel spreadsheets programmatically. Claude should apply these patterns when users need to generate data reports, financial models, automate Excel workflows, or process spreadsheet data. **Modern Best Practices (Jan 2026)**: - Treat spreadsheets as software: clear inputs/outputs, auditability, and versioning. - Protect data integrity: control totals, validation, and traceability to sources. - Accessibility: labels, contrast, structure; use Excel's Accessibility Checker; meet procurement/regulatory requirements when distributing externally. - If distributing in the EU or regulated contexts, follow applicable accessibility requirements (often aligned with EN 301 549 / WCAG). - Ship with a review loop and an owner (avoid "mystery models"). - Security: treat untrusted input/workbooks as hostile (formula injection, external links, hidden content, macros). --- ## Quick Reference | Task | Tool/Library | Language | When to Use | |------|--------------|----------|-------------| | Create XLSX | ExcelJS | Node.js | Reports, data exports | | Create XLSX | openpyxl | Python | Read/write, modify existing files | | Create XLSX | XlsxWriter | Python | Write-only, rich formatting, charts | | Data analysis | pandas + openpyxl | Python | DataFrame to Excel with formatting | | Read XLSX | xlsx (SheetJS) | Node.js | Parse spreadsheets | | Charts | openpyxl/XlsxWriter | Python | Embedded visualizatio...

Details

Author: vasilyu1983
Repository: vasilyu1983/AI-Agents-public
Created: 9 months ago
Last Updated: 1 weeks ago
Language: Python
License: MIT

Integrates with

OpenAI · AI Anthropic · AI

Similar Skills

Semantically similar based on skill content — not just same category

Data & Documents Listed

xlsx

Create, read, edit spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Supports formulas, formatting, charts, data cleaning, and financial modeling conventions.

1 Updated 2 weeks ago

Data & Documents Listed

xlsx

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, .xltx, .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.

0 Updated 2 weeks ago

Data & Documents Solid

xlsx

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, .xltx, .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.

18 Updated 2 days ago