XLSX
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the...
Install
npx skills add K-Dense-AI/claude-scientific-writer --skill xlsx -g -a claude-code -y- Repository
- K-Dense-AI/claude-scientific-writer2.5k
- Category
- Documents
- Updated
- 5d ago
- License
- MIT
- Context cost
- Mediumabout 1,929 tokens
- Runs scripts
- Yes, review before use
What it does
Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm, .xltx) where the workbook file is the primary deliverable. Use for formulas, formatting, financial models, multi-sheet workbooks, and tabular cleanup exported to Excel. Also applies to .csv/.tsv when the user wants spreadsheet output. Do NOT use for Word documents, HTML reports, standalone Python scripts, database pipelines, or Google Sheets API work.
XLSX creation, editing, and analysis
| Task | Approach |
|---|---|
| Create or edit with formulas/formatting | openpyxl, see gotchas below |
| Bulk data in or out | pandas (read_excel, to_excel) |
| Quick look at a sheet | markitdown file.xlsx, ## SheetName per sheet; reads .xlsm too. No cell coordinates, so don't plan edits from it |
| Read a model (formulas and values) | two load_workbook passes, see gotchas |
openpyxl,pandas, andmarkitdownare preinstalled, do not runuv pip installfirst; write the script and import directly. Only if an import fails (or themarkitdowncommand is missing):uv pip installthe missing package.
Script paths below are relative to this skill's directory.
