Skip to main content
excel Read, write, edit, and format Excel files (.xlsx). Create spreadsheets, manipulate data, apply formatting, manage sheets, merge cells, find/replace, and export to CSV/JSON/Markdown. Use for any Excel file manipulation task.
Zur Installation springen Skills Marktplatz Entdecken und erkunden Sie KI-Skills, die von der Community erstellt wurden.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Prompt-Details anzeigen Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.
npx skills add https://github.com/duclm1x1/Dive-Ai --skill excelDer Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.
Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.
ZIP herunterladen Herunterladen... Verwandte Berufe SOC
Basierend auf der SOC-Berufsklassifikation
Mehr aus diesem Repository Persistent memory system for AI agents following Model Context Protocol (MCP). Use for storing long-term memories across sessions, semantic search of past knowledge, building knowledge graphs, auto-injecting context, deduplicating memories, syncing to cloud storage. Essential for agents that need to remember decisions, solutions, preferences, and learned patterns over time.
Persistent memory system for AI agents following Model Context Protocol (MCP). Use for storing long-term memories across sessions, semantic search of past knowledge, building knowledge graphs, auto-injecting context, deduplicating memories, syncing to cloud storage. Essential for agents that need to remember decisions, solutions, preferences, and learned patterns over time.
Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.
name excel description Read, write, edit, and format Excel files (.xlsx). Create spreadsheets, manipulate data, apply formatting, manage sheets, merge cells, find/replace, and export to CSV/JSON/Markdown. Use for any Excel file manipulation task. metadata {"clawdbot":{"emoji":"📊","requires":{"bins":["python3"],"pip":["openpyxl"]}}}
Excel
Comprehensive Excel file manipulation - read, write, edit, format, and export.
Setup
pip install openpyxl
uv run --with openpyxl python3 scripts/excel.py --help
Quick Reference
cd skills/excel
python3 scripts/excel.py info report.xlsx
python3 scripts/excel.py read report.xlsx
python3 scripts/excel.py read report.xlsx --format markdown
python3 scripts/excel.py read report.xlsx --sheet "Sales" --range A1:D10
python3 scripts/excel.py cell report.xlsx B5
python3 scripts/excel.py create output.xlsx
python3 scripts/excel.py create output.xlsx --sheets "Data,Summary,Charts"
python3 scripts/excel.py write output.xlsx --data '[[1,2,3],[4,5,6]]'
python3 scripts/excel.py write output.xlsx --data '{"headers":["Name","Age"],"rows":[["Alice",30],["Bob",25]]}'
"New Value"
"SUM(A1:A10)"
Commands
Reading Data info - Get workbook metadata
python3 scripts/excel.py info report.xlsx
python3 scripts/excel.py read file.xlsx
python3 scripts/excel.py read file.xlsx --format csv
python3 scripts/excel.py read file.xlsx --format markdown
python3 scripts/excel.py read file.xlsx --sheet "Sheet2"
python3 scripts/excel.py read file.xlsx --range A1:D10
cell - Read a specific cell
python3 scripts/excel.py cell file.xlsx A1
python3 scripts/excel.py cell file.xlsx B5 --sheet "Data"
Creating & Writing create - Create new workbook
python3 scripts/excel.py create new.xlsx
python3 scripts/excel.py create new.xlsx --sheets "Sheet1,Sheet2,Summary"
write - Write data to cells
python3 scripts/excel.py write file.xlsx --data '[[1,2,3],[4,5,6]]'
python3 scripts/excel.py write file.xlsx --data '{"headers":["A","B"],"rows":[[1,2],[3,4]]}'
python3 scripts/excel.py write file.xlsx --data '[[1,2]]' --start C5
python3 scripts/excel.py write file.xlsx --data '{"Name":"Alice","Age":30}'
from-csv - Create Excel from CSV
python3 scripts/excel.py from-csv data.csv output.xlsx
python3 scripts/excel.py from-csv data.csv output.xlsx --sheet "Imported"
from-json - Create Excel from JSON
python3 scripts/excel.py from-json data.json output.xlsx
Editing edit - Edit a cell value or formula
python3 scripts/excel.py edit file.xlsx A1 "New Value"
python3 scripts/excel.py edit file.xlsx B2 100
python3 scripts/excel.py edit file.xlsx C3 "SUM(A1:B2)" --formula
python3 scripts/excel.py edit file.xlsx D4 "=VLOOKUP(A1,Data!A:B,2,FALSE)" --formula
python3 scripts/excel.py find file.xlsx "search term"
python3 scripts/excel.py find file.xlsx "error" --sheet "Log"
replace - Find and replace
python3 scripts/excel.py replace file.xlsx "old" "new"
python3 scripts/excel.py replace file.xlsx "2024" "2025" --sheet "Dates"
Sheet Management add-sheet - Add a new sheet
python3 scripts/excel.py add-sheet file.xlsx "NewSheet"
python3 scripts/excel.py add-sheet file.xlsx "First" --position 0
rename-sheet - Rename a sheet
python3 scripts/excel.py rename-sheet file.xlsx "Sheet1" "Data"
delete-sheet - Delete a sheet
python3 scripts/excel.py delete-sheet file.xlsx "OldSheet"
copy-sheet - Copy a sheet
python3 scripts/excel.py copy-sheet file.xlsx "Template" "January"
Row & Column Operations insert-rows - Insert rows
python3 scripts/excel.py insert-rows file.xlsx 5
python3 scripts/excel.py insert-rows file.xlsx 5 --count 3
insert-cols - Insert columns
python3 scripts/excel.py insert-cols file.xlsx C
python3 scripts/excel.py insert-cols file.xlsx 3 --count 2
delete-rows - Delete rows
python3 scripts/excel.py delete-rows file.xlsx 5
python3 scripts/excel.py delete-rows file.xlsx 5 --count 3
delete-cols - Delete columns
python3 scripts/excel.py delete-cols file.xlsx C
python3 scripts/excel.py delete-cols file.xlsx B --count 2
Cell Operations python3 scripts/excel.py merge file.xlsx A1:C1
python3 scripts/excel.py merge file.xlsx A1:A5 --sheet "Header"
python3 scripts/excel.py unmerge file.xlsx A1:C1
Formatting format - Apply cell formatting
python3 scripts/excel.py format file.xlsx A1:D1 --bold --italic
python3 scripts/excel.py format file.xlsx A1:D1 --font-size 14 --font-color RED --font-name "Arial"
python3 scripts/excel.py format file.xlsx A1:D1 --bg-color YELLOW
python3 scripts/excel.py format file.xlsx A:A --align center --valign top
python3 scripts/excel.py format file.xlsx B2:B100 --wrap
python3 scripts/excel.py format file.xlsx A1:D10 --border thin
python3 scripts/excel.py format file.xlsx A1:D1 --bold --bg-color "#4472C4" --font-color WHITE --align center
resize - Resize rows and columns
python3 scripts/excel.py resize file.xlsx --row 1:30
python3 scripts/excel.py resize file.xlsx --col A:20
python3 scripts/excel.py resize file.xlsx --row 1:30 --col A:15 --col B:25
python3 scripts/excel.py freeze file.xlsx A2
python3 scripts/excel.py freeze file.xlsx B1
python3 scripts/excel.py freeze file.xlsx B2
Export python3 scripts/excel.py to-csv file.xlsx output.csv
python3 scripts/excel.py to-csv file.xlsx data.csv --sheet "Data"
to-json - Export to JSON (first row as headers)
python3 scripts/excel.py to-json file.xlsx output.json
to-markdown - Export to markdown table
python3 scripts/excel.py to-markdown file.xlsx
python3 scripts/excel.py to-markdown file.xlsx --sheet "Summary"
Colors Named colors: RED, GREEN, BLUE, YELLOW, WHITE, BLACK, GRAY, ORANGE, PURPLE, PINK, CYAN
Hex colors: #FF0000, #4472C4, 00FF00 (with or without #)
Common Workflows
Create a report from data
python3 scripts/excel.py from-json sales.json report.xlsx --sheet "Sales"
python3 scripts/excel.py format report.xlsx A1:E1 --bold --bg-color "#4472C4" --font-color WHITE
python3 scripts/excel.py freeze report.xlsx A2
python3 scripts/excel.py resize report.xlsx --col A:15 --col B:25 --col C:12
Update existing report
python3 scripts/excel.py insert-rows report.xlsx 2
python3 scripts/excel.py write report.xlsx --data '[["New Item", 100, 50]]' --start A2
python3 scripts/excel.py edit report.xlsx D10 "=SUM(D2:D9)" --formula
python3 scripts/excel.py replace report.xlsx "2024" "2025"
Extract data for analysis
python3 scripts/excel.py read data.xlsx --format json > data.json
python3 scripts/excel.py read data.xlsx --range A1:D20 --format markdown
python3 scripts/excel.py to-csv data.xlsx --sheet "Raw Data" export.csv
Output Format All commands output JSON with success: true/false:
{
"success" : true ,
"file" : "report.xlsx" ,
"sheet" : "Sheet1" ,
...
}
Use --format markdown or --format csv with read command for alternative output.
