mediar-ai/packages/skills/skills/xlsx-toolkit
packages/skills/skills/xlsx-toolkit/SKILL.md
# XLSX Toolkit Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. ## Prerequisites - Python 3.8+ - Libraries: openpyxl, pandas - Optional: LibreOffice (for formula recalculation) ## Instructions 1. **Read and analyze Excel data with pandas** ```python import pandas as pd df = pd.read_excel('file.xlsx') all_sheets = pd.read_excel('file.xlsx', sheet_name=None) df.describe() # Statistics ``` 2.
$ install --global
skillsauthnpx skillsauth add mediar-ai/skillhubz packages/skills/skills/xlsx-toolkitInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 20, 2026, 6:24 AM11.7s2 files scanned
SKILL.md
XLSX Toolkit
Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization.
Prerequisites
- Python 3.8+
- Libraries: openpyxl, pandas
- Optional: LibreOffice (for formula recalculation)
Instructions
-
Read and analyze Excel data with pandas
import pandas as pd df = pd.read_excel('file.xlsx') all_sheets = pd.read_excel('file.xlsx', sheet_name=None) df.describe() # Statistics -
Create new Excel files with openpyxl
from openpyxl import Workbook from openpyxl.styles import Font, PatternFill wb = Workbook() sheet = wb.active sheet['A1'] = 'Hello' sheet['B2'] = '=SUM(A1:A10)' # Use formulas, not hardcoded values sheet['A1'].font = Font(bold=True) wb.save('output.xlsx') -
Edit existing files preserving formulas
from openpyxl import load_workbook wb = load_workbook('existing.xlsx') sheet = wb.active sheet['A1'] = 'New Value' wb.save('modified.xlsx') -
Always use Excel formulas instead of hardcoding
# WRONG: sheet['B10'] = total # CORRECT: sheet['B10'] = '=SUM(B2:B9)' sheet['C5'] = '=(C4-C2)/C2' sheet['D20'] = '=AVERAGE(D2:D19)' -
Financial model color standards
- Blue text: Hardcoded inputs
- Black text: All formulas
- Green text: Links from other sheets
- Yellow background: Key assumptions
-
Number formatting
- Currency: $#,##0 with units in headers
- Percentages: 0.0% format
- Negative numbers: Use parentheses (123) not -123
Error Handling
- If formulas show errors (#REF!, #DIV/0!), verify cell references
- Use
data_only=Trueto read calculated values (but formulas are lost) - For large files, use
read_only=Trueorwrite_only=True
Notes
- Use pandas for data analysis and bulk operations
- Use openpyxl for formulas, formatting, and Excel-specific features
- Cell indices are 1-based in openpyxl
- Recalculate formulas with LibreOffice if needed
Source: anthropics/skills
Related Skills
mediar-ai/tui-ui
tools
VerifiedTrustedCommunity
Design web-like user interfaces in the terminal and inside tmux with a cell-grid Canvas, CSS-like box model, flexbox/grid layout, and 15 reusable widgets such as Panel, Table, Card, ProgressBar, Meter, Tabs, Tree, Badge, Banner, and a braille line chart. Use when an agent needs a dashboard, panel, table, status page, TUI layout, tmux dashboard, screenshot-driven CLI/TUI replica, ANSI frame, truecolor render, pyte PNG screenshot smoke test, wide-character alignment, or a new terminal widget.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/drive-tui
tools
VerifiedTrustedCommunity
Drive interactive terminal (TUI) programs — CLIs, REPLs, installers, menu apps, agent CLIs, and editors like vim — through a PTY, reading semantic screen snapshots. A pattern library classifies a screen (REPL, menu, pager, fzf search, confirm dialog, form, spinner, wizard) and drives it with a ready recipe. Use when a program expects a live terminal (arrow-key menus, prompts, spinners, password fields, curses UIs), or when a piped command hangs or prints nothing.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/cmd-art
tools
VerifiedTrustedCommunity
Design and render terminal/CMD visual effects and ASCII art from a one-line request via the pluggable `fx` engine (18 hot-swappable, themeable effects plus scripted shows). Effects include donut, matrix rain, plasma, fire, a spinning 3D ball, Game of Life, wireframe cube, 3D text banners, rainbow/lolcat gradient text, starfield, tunnel, fireworks, image-to-ASCII, and more. Use when the request is for a terminal animation, ANSI/CLI art, or a new console effect. Pure Python stdlib; truecolor.
7SKILL.mdUpdated Jul 11, 2026
mediar-ai/packages/skills/skills/x-twitter-scraper
tools
VerifiedTrustedCommunity
# X Twitter Scraper Use Xquik for X/Twitter tweet search, user lookup, profile tweets, follower export, media download, monitors, webhooks, posting workflows, and MCP-backed API exploration. ## Prerequisites - A Xquik API key in `XQUIK_API_KEY`. - Internet access to `https://xquik.com/api/v1`, `https://xquik.com/mcp`, and `https://docs.xquik.com`. - A clear user request that identifies the target tweets, users, accounts, keywords, media, monitor, webhook, or write action. ## Source Truth -
6SKILL.mdUpdated May 31, 2026