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

from praisonaiagents import Agent
from praisonai_tools import read_excel, write_excel

agent = Agent(name="Analyst", tools=[read_excel, write_excel])
agent.start("Total revenue in Q1 from reports/sales.xlsx")

The user references a spreadsheet; the agent reads and updates Excel workbooks via tools.

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]
)

Related

Custom Tools

Build your own agent tools

Tools Overview

Browse PraisonAI tool documentation