Excel Agent

Excel file processing tools for AI agents.

Prerequisites

• Python 3.10 or higher
• PraisonAI Agents package installed
• PraisonAI Tools package installed
• openpyxl package installed

Excel Tools

Use Excel Tools to read, write, and manipulate Excel files with AI agents.

1. Install Dependencies

   First, install the required packages:

   pip install praisonaiagents praisonai-tools openpyxl
   
2. Import Components

   Import the necessary components:

   from praisonaiagents import Agent, Task, AgentTeam
   from praisonai_tools import read_excel, write_excel, merge_excel
   
3. Create Agent

   Create an Excel processing agent:

   excel_agent = Agent(
       name="ExcelProcessor",
       role="Excel Processing Specialist",
       goal="Process Excel files efficiently and accurately.",
       backstory="Expert in Excel file manipulation and analysis.",
       tools=[read_excel, write_excel, merge_excel],
       reflection=False
   )
   
4. Define Task

   Define the Excel processing task:

   excel_task = Task(
       description="Process and analyze Excel spreadsheet data.",
       expected_output="Processed Excel data with analysis.",
       agent=excel_agent,
       name="excel_processing"
   )
   
5. Run Agent

   Initialize and run the agent:

   agents = AgentTeam(
       agents=[excel_agent],
       tasks=[excel_task],
       process="sequential"
   )
   agents.start()
   

Understanding Excel Tools

What are Excel Tools?

Excel Tools provide Excel processing capabilities for AI agents:

• File reading with sheet selection
• Data writing with formatting
• Multi-file merging
• Cell-level operations
• Format preservation

Key Components

Excel Agent

Create specialized Excel agents:

Agent(tools=[read_excel, write_excel, merge_excel])

Excel Task

Define Excel tasks:

Task(description="excel_operation")

Process Types

Sequential or parallel processing:

process="sequential"

Excel Options

Customize Excel parameters:

sheet_name="Sheet1", header=0

Available Functions

from praisonai_tools import read_excel
from praisonai_tools import write_excel
from praisonai_tools import merge_excel

Examples

Basic Excel Processing Agent

from praisonaiagents import Agent, Task, AgentTeam
from praisonai_tools import read_excel, write_excel, merge_excel

# Create Excel agent
excel_agent = Agent(
    name="ExcelExpert",
    role="Excel Processing Specialist",
    goal="Process Excel files efficiently and accurately.",
    backstory="Expert in spreadsheet analysis and manipulation.",
    tools=[read_excel, write_excel, merge_excel],
    reflection=False
)

# Define Excel task
excel_task = Task(
    description="Process and analyze sales spreadsheets.",
    expected_output="Consolidated sales report.",
    agent=excel_agent,
    name="sales_processing"
)

# Run agent
agents = AgentTeam(
    agents=[excel_agent],
    tasks=[excel_task],
    process="sequential"
)
agents.start()

Advanced Excel Processing with Multiple Agents

from praisonaiagents import Agent, Task, AgentTeam
from praisonai_tools import read_excel, write_excel, merge_excel

# Create Excel processing agent
processor_agent = Agent(
    name="Processor",
    role="Excel Processor",
    goal="Process Excel files systematically.",
    tools=[read_excel, write_excel, merge_excel],
    reflection=False
)

# Create analysis agent
analysis_agent = Agent(
    name="Analyzer",
    role="Data Analyst",
    goal="Analyze processed Excel data.",
    backstory="Expert in data analysis and reporting.",
    reflection=False
)

# Define tasks
processing_task = Task(
    description="Process and merge Excel files.",
    agent=processor_agent,
    name="excel_processing"
)

analysis_task = Task(
    description="Analyze processed data and create reports.",
    agent=analysis_agent,
    name="excel_analysis"
)

# Run agents
agents = AgentTeam(
    agents=[processor_agent, analysis_agent],
    tasks=[processing_task, analysis_task],
    process="sequential"
)
agents.start()

Best Practices

Agent Configuration

Configure agents with clear Excel focus:

from praisonai_tools import read_excel, write_excel, merge_excel

Agent(
    name="ExcelProcessor",
    role="Excel Processing Specialist",
    goal="Process Excel files accurately and efficiently",
    tools=[read_excel, write_excel, merge_excel]
)

Task Definition

Define specific Excel operations:

Task(
    description="Process sales reports and generate summaries",
    expected_output="Consolidated sales report"
)

Common Patterns

Excel Processing Pipeline

from praisonaiagents import Agent, Task, AgentTeam
from praisonai_tools import read_excel, write_excel, merge_excel

# Processing agent
processor = Agent(
    name="Processor",
    role="Excel Processor",
    tools=[read_excel, write_excel, merge_excel]
)

# Analysis agent
analyzer = Agent(
    name="Analyzer",
    role="Data Analyst"
)

# Define tasks
process_task = Task(
    description="Process Excel files",
    agent=processor
)

analyze_task = Task(
    description="Analyze processed data",
    agent=analyzer
)

# Run workflow
agents = AgentTeam(
    agents=[processor, analyzer],
    tasks=[process_task, analyze_task]
)