📊 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

{
  "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

{
  "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

{
  "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

{
  "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

{
  "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

{
  "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)

{
  "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