Praison AI

Excel Agent

Excel file processing tools for AI agents.

python
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.

Diagram

Input

Agent

Tool

Output

Diagram
Excel AgentAgentUserExcel AgentAgentUserRequestProcess requestResultResponse

Excel Tools

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

  1. Install Dependencies

    First, install the required packages:

    bash
    pip install praisonaiagents praisonai-tools openpyxl
  2. Import Components

    Import the necessary components:

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

    Create an Excel processing agent:

    python
    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:

    python
    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:

    python
    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:

python
Agent(tools=[read_excel, write_excel, merge_excel])
 Excel Task

Define Excel tasks:

python
Task(description="excel_operation")
 Process Types

Sequential or parallel processing:

python
process="sequential"
 Excel Options

Customize Excel parameters:

python
sheet_name="Sheet1", header=0

Available Functions

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

Examples

Basic Excel Processing Agent

python
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

python
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:

python
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:

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

Common Patterns

Excel Processing Pipeline

python
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