Habilidades xlsx
📊

xlsx

Seguro 🌐 Acesso à rede⚙️ Comandos externos📁 Acesso ao sistema de arquivos

Create and Edit Excel Spreadsheets

Também disponível em: AutumnsGrove,Cam10001110101,ZhanlinCui,davila7,Azeem-2,anthropics,ArtemisAI,DYAI2025,ComposioHQ,K-Dense-AI

This skill enables Claude to create, edit, and analyze Excel spreadsheets with formulas, formatting, and data analysis. It solves the problem of manual spreadsheet work by automating file creation and modification tasks.

Suporta: Claude Codex Code(CC)
🥉 72 Bronze
1

Baixar o ZIP da skill

2

Upload no Claude

Vá em Configurações → Capacidades → Skills → Upload skill

3

Ative e comece a usar

Testar

A utilizar "xlsx". Create a sales report with monthly revenue in column B, YoY growth in column C using formulas, and green text for positive growth, red for negative.

Resultado esperado:

Created sales_report.xlsx with 3 sheets (Summary, Monthly Data, YoY Analysis). Applied formula =((B3-B2)/B2) for growth calculation. Green font (RGB 0,128,0) for positive values, red (RGB 255,0,0) for negative. All formulas verified with zero errors.

A utilizar "xlsx". Read the budget.xlsx file and tell me which categories have variances greater than 10%.

Resultado esperado:

Analyzed budget.xlsx (5 sheets, 1,240 rows). Found 3 categories with variances over 10%: Marketing (-15.2%), Travel (-12.8%), Software (+11.4%). Summary table created with variance percentages and status indicators.

Auditoria de Segurança

Seguro
v1 • 2/25/2026

All 59 static findings are false positives. The skill is a legitimate spreadsheet operations tool using openpyxl for Excel file manipulation and LibreOffice for formula recalculation. Network URLs are legal documentation links. External commands invoke soffice (LibreOffice) - a standard spreadsheet application. Filesystem access is limited to user config directories for macro setup. Code examples in SKILL.md use Markdown formatting. Excel formulas flagged as C2 keywords are standard spreadsheet syntax.

3
Arquivos analisados
498
Linhas analisadas
3
achados
1
Total de auditorias

Fatores de risco

🌐 Acesso à rede (3)
LICENSE.txt:8 LICENSE.txt:9 recalc.py:37
⚙️ Comandos externos (3)
recalc.py:31 recalc.py:84 recalc.py:92
📁 Acesso ao sistema de arquivos (3)
recalc.py:21 recalc.py:46 recalc.py:33
Auditado por: claude

Pontuação de qualidade

38
Arquitetura
90
Manutenibilidade
87
Conteúdo
50
Comunidade
100
Segurança
91
Conformidade com especificações

O Que Você Pode Construir

Financial Analyst Creates Budget Model

A financial analyst needs to build a quarterly budget model with color-coded inputs and formulas that auto-calculate totals and variances.

Data Analyst Merges Data Sources

A data analyst wants to read multiple CSV files, combine the data, and export to a formatted Excel report with summary calculations.

Project Manager Tracks Deliverables

A project manager needs to create a tracking spreadsheet with status columns, conditional formatting, and automated progress calculations.

Tente Estes Prompts

Create Simple Spreadsheet 
Create an Excel file named [filename.xlsx] with the following data: [describe data]. Include formulas for [describe calculations].
Analyze Existing Data 
Read the Excel file [filename.xlsx] and provide a summary of the data including: total rows, column names, any missing values, and basic statistics.
Update Financial Model 
Update the Excel file [filename.xlsx] by: 1) Changing the growth rate in cell [cell] to [value], 2) Adding a new column for [description], 3) Ensuring all formulas recalculate correctly.
Build Complex Report 
Create a professional Excel report with: multiple sheets (Summary, Details, Charts), pivot-style summaries, conditional formatting for [conditions], and proper number formatting for currency/percentages.

Melhores Práticas

  • Always use Excel formulas instead of hardcoded calculated values to maintain spreadsheet interactivity
  • Apply proper number formatting (currency symbols, decimal places, negative number display) for readability
  • Test formulas on sample cells before applying across large datasets
  • Use the recalc.py script after any modification to verify formula integrity

Evitar

  • Do not calculate values in Python and hardcode them into cells - use Excel formulas instead
  • Avoid opening files with data_only=True and saving, as this permanently deletes formulas
  • Do not ignore formula errors - always run recalc.py and fix #REF!, #DIV/0!, and other errors
  • Avoid verbose variable names and excessive comments in generated Python code

Perguntas Frequentes

Does this skill work with .xlsx, .xlsm, .csv, and .tsv files?
Yes. The skill supports .xlsx (Excel with formulas), .xlsm (macro-enabled), .csv (comma-separated), and .tsv (tab-separated) files.
Why do I need to run recalc.py after creating a spreadsheet?
openpyxl saves formulas as text strings without calculating their values. recalc.py uses LibreOffice to actually compute formula results.
Can I preserve existing formatting when editing a file?
Yes. Use load_workbook() to open existing files - openpyxl preserves all formatting, formulas, and styles by default.
What color coding is used for financial models?
Standard convention: Blue (RGB 0,0,255) for inputs, Black for formulas, Green for worksheet links, Red for external links, Yellow background for key assumptions.
How do I handle division by zero errors in formulas?
Use IFERROR or IF with ISNUMBER to check denominators. Example: =IF(B2=0, 0, A2/B2) or =IFERROR(A2/B2, 0).
Can this skill read password-protected Excel files?
No. Password-protected files cannot be read or modified by openpyxl due to security restrictions.

Detalhes do Desenvolvedor

Autor

sickn33

Licença

Proprietary

Repositório

https://github.com/sickn33/antigravity-awesome-skills/tree/main/web-app/public/skills/xlsx-official

Referência

main

Estrutura de arquivos

📄 LICENSE.txt

📄 recalc.py

📄 SKILL.md