📊 Excel Automation Suite - 121 Powerful Tools > 🚀 The most comprehensive Excel automation actor on Apify! Create, edit, format, and analyze Excel files with 121 professional-grade tools. ## 🌟 Why Choose This Actor? - 🎯 121 Tools - The largest collection of Excel automation tools available - ⚡ Fast Execution - Optimized for speed, completes tasks in seconds - 🔧 Production Ready - Full error handling, logging, and validation - 📈 Business Grade - Professional features for enterprise workflows - 🎨 Rich Formatting - Advanced styling, conditional formatting, charts - 📊 Data Analysis - Pivot tables, statistics, correlations, ranking - 🔄 Two Modes - Direct execution or MCP server for AI assistants ## 💼 Perfect For - Business Reporting - Automated report generation and distribution - Data Processing - Transform, clean, and analyze large datasets - Financial Analysis - Create financial models and dashboards - Business Intelligence - Generate insights from raw data - Workflow Automation - Integrate Excel into your automation pipelines ## 🚀 Quick Start ### Simple Example json { "mode": "direct", "tool": "excel_write_range", "arguments": { "file_path": "sales_report.xlsx", "sheet_name": "Sheet1", "start_cell": "A1", "data": [ ["Product", "Q1 Sales", "Q2 Sales"], ["Widget A", 15000, 18000], ["Widget B", 12000, 14500] ] } } This creates an Excel file with your data - it's that simple! ## 📚 Tool Categories ### 1️⃣ Basic Operations (34 tools) - Create, open, save workbooks - Read/write cells and ranges - Insert/delete rows and columns - Format cells (fonts, colors, alignment) - Add borders and merge cells - Number formatting ### 2️⃣ Charts & Visualization (16 tools) - Bar, Column, Line, Pie charts - Scatter, Area, Radar, Bubble charts - Stock, Doughnut, 3D charts - Waterfall and Funnel charts - Custom chart positioning and styling ### 3️⃣ Formulas & Calculations (9 tools) - Write and evaluate formulas - Trace formula dependencies - Find precedents and dependents - Name manager for ranges - Dynamic formula evaluation ### 4️⃣ Data Analysis (11 tools) - Pivot tables with aggregations - Statistical analysis - Correlation matrices - Data ranking and sorting - Subtotals and grouping ### 5️⃣ Conditional Formatting (15 tools) - Color scales (2-color, 3-color) - Data bars with custom colors - Icon sets (3, 4, 5 icons) - Cell value rules - Formula-based rules - Top/Bottom N rules - Above/Below average - Unique/Duplicate values ### 6️⃣ Paste Special Operations (6 tools) - Paste values only - Paste formats only - Paste formulas only - Transpose data - Paste with operations (add, subtract, multiply, divide) - Paste column widths ### 7️⃣ Table Operations (7 tools) - Create formatted tables - Add total rows with functions - Resize and convert tables - Apply table styles - Sort and filter tables - List all tables in workbook ### 8️⃣ Sparklines (5 tools) - Line sparklines - Column sparklines - Win/Loss sparklines - Custom sparkline styling - Group sparkline operations ### 9️⃣ Import/Export (8 tools) - JSON import/export - CSV import/export - HTML table export - Batch operations ### 🔟 Workbook Management (10 tools) - Sheet operations - Workbook properties - Protection and passwords - Named ranges - Print settings - Comments and hyperlinks ## 📖 Common Use Cases ### 📊 Sales Report Generation json { "mode": "direct", "tool": "excel_create_pivot_table", "arguments": { "file_path": "sales.xlsx", "source_sheet": "RawData", "source_range": "A1:E1000", "target_sheet": "Report", "target_cell": "A1", "rows": ["Region", "Salesperson"], "columns": ["Quarter"], "values": [{"field": "Sales", "function": "sum"}] } } ### 📈 Chart Creation json { "mode": "direct", "tool": "excel_add_chart", "arguments": { "file_path": "report.xlsx", "sheet_name": "Dashboard", "chart_type": "column", "data_range": "A1:C10", "chart_title": "Quarterly Performance", "position": "E2" } } ### 🎨 Conditional Formatting json { "mode": "direct", "tool": "excel_conditional_format_color_scale", "arguments": { "file_path": "data.xlsx", "sheet_name": "Sheet1", "cell_range": "B2:B100", "color_scale_type": "3color", "min_color": "FF0000", "mid_color": "FFFF00", "max_color": "00FF00" } } ### 📋 Data Import from JSON json { "mode": "direct", "tool": "excel_import_json", "arguments": { "file_path": "output.xlsx", "sheet_name": "ImportedData", "json_data": [ {"name": "John", "age": 30, "city": "NYC"}, {"name": "Jane", "age": 25, "city": "LA"} ], "start_cell": "A1" } } ## 🔧 Input Schema json { "mode": "direct", // "direct" for single tool execution "tool": "tool_name", // Name of the tool to execute "arguments": { // Tool-specific arguments "file_path": "file.xlsx", // ... other arguments } } ### Server Mode (for MCP integration) json { "mode": "server", "port": 8000 } ## 📤 Output The actor saves: - Excel files in the key-value store (download from OUTPUT tab) - Execution results in the dataset with status and details - Logs for debugging and monitoring ## 🎓 Advanced Features ### Formula Evaluation Automatically evaluates formulas and returns calculated values ### Cell Protection Protect sheets with passwords to prevent unauthorized edits ### Data Validation Create dropdown lists and input constraints ### Print Settings Configure page layout, headers, footers for professional printouts ### Named Ranges Create reusable named ranges for complex formulas ## 🏆 Competition Advantages 1. Most Comprehensive - 121 tools vs typical 20-50 from competitors 2. Production Ready - Full error handling and validation 3. Well Documented - Complete examples and use cases 4. Dual Mode - Works standalone or as MCP server 5. Business Focused - Built for real-world enterprise needs ## 📞 Support & Documentation - Full Tool Reference: Check INPUT tab for complete tool list - Integration Guide: MCP server mode for AI assistants - Examples: 20+ working examples included - Issue Reporting: Use GitHub issues for bug reports ## 🔐 Privacy & Security - All processing happens in isolated containers - No data is stored after run completion - Files are automatically cleaned up - Password-protected sheet support ## 📜 License Apache 2.0 - Free for commercial and personal use ## 🌟 Star Features - ✅ Zero Configuration - Works out of the box - ✅ Fast Processing - Optimized for speed - ✅ Error Recovery - Graceful error handling - ✅ Batch Operations - Process multiple files - ✅ Memory Efficient - Handles large datasets - ✅ Type Safe - Full validation of inputs --- Ready to automate your Excel workflows? Click "Start" to begin! 🚀 Made with ❤️ for the Apify community