xlsx
Create and edit Excel spreadsheets
متاح أيضًا من: davila7,Cam10001110101,ComposioHQ,anthropics,ArtemisAI,DYAI2025,K-Dense-AI,AutumnsGrove
Users need to work with spreadsheet data for financial modeling, reporting, and analysis. This skill provides tools to create, modify, and analyze Excel files with full formula support, formatting options, and data visualization capabilities.
تنزيل ZIP المهارة
رفع في Claude
اذهب إلى Settings → Capabilities → Skills → Upload skill
فعّل وابدأ الاستخدام
اختبرها
استخدام "xlsx". Create a simple budget spreadsheet with income and expense categories
النتيجة المتوقعة:
- Created budget.xlsx with columns for Category, Description, Amount, and Type
- Added 5 sample categories: Software Licenses, Cloud Services, Marketing, Office Supplies, Contractors
- Applied currency formatting ($#,##0) with parentheses for negative values
- Formula in column C calculates totals automatically
استخدام "xlsx". Analyze the sales data and identify trends
النتيجة المتوقعة:
- Loaded sales_data.xlsx with 1500 rows across 12 columns
- Total revenue: $2.4M with monthly growth averaging 8.3%
- Peak sales in Q4 (42% of annual revenue)
- Top 3 products account for 67% of total sales
التدقيق الأمني
مخاطر منخفضةLegitimate spreadsheet manipulation skill with controlled subprocess execution for LibreOffice formula recalculation. All subprocess calls use hardcoded commands (soffice) with no user input injection risk. The static findings represent false positives triggered by: (1) Excel cell references like C2 being misinterpreted as C2 malware indicators, (2) documentation text matching security scanner patterns, and (3) legitimate LibreOffice configuration file access. No credential theft, data exfiltration, or malicious patterns detected.
مشكلات منخفضة المخاطر (2)
عوامل الخطر
⚡ يحتوي على سكربتات (1)
📁 الوصول إلى نظام الملفات (1)
⚙️ الأوامر الخارجية (1)
درجة الجودة
ماذا يمكنك بناءه
Build Financial Models
Create discounted cash flow models, valuation spreadsheets, and financial projections with proper color coding.
Analyze Dataset Exports
Import CSV or Excel data, perform statistical analysis with pandas, and export formatted results.
Generate Reports
Build formatted reports with charts, summaries, and calculated metrics for stakeholders.
جرّب هذه الموجهات
Create an Excel file named budget.xlsx with monthly revenue and expense data. Add a formula in column C that calculates profit (revenue minus expenses). Apply currency formatting.
Read the file sales_data.xlsx and provide summary statistics including total, average, min, and max for each numerical column.
Run the recalc.py script on financial_model.xlsx to recalculate all formulas and report any errors found.
Create a three-sheet workbook: assumptions sheet with growth rates and margins, projections sheet with formulas referencing assumptions, and summary sheet with key metrics and charts.
أفضل الممارسات
- Always use Excel formulas instead of hardcoded values to keep spreadsheets dynamic and updateable
- Place assumptions (growth rates, margins) in separate cells with clear references in formulas
- Run recalc.py after creating or modifying spreadsheets with formulas to verify zero errors
تجنب
- Hardcoding calculated values instead of using Excel formulas
- Opening files with data_only=True mode when you need to preserve formulas
- Forgetting to run recalc.py after creating formula-based spreadsheets
الأسئلة المتكررة
What file formats are supported?
What are the file size limits?
Can I integrate this with other tools?
Is my data safe?
Why are formulas not calculating immediately?
How does this compare to manual Excel work?
تفاصيل المطور
بنية الملفات