Skip to main content
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, Agents
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 = Agents(
    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, Agents
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 = Agents(
    agents=[excel_agent],
    tasks=[excel_task],
    process="sequential"
)
agents.start()

​
Advanced Excel Processing with Multiple Agents

from praisonaiagents import Agent, Task, Agents
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 = Agents(
    agents=[processor_agent, analysis_agent],
    tasks=[processing_task, analysis_task],
    process="sequential"
)
agents.start()

​
Best Practices

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]
)
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, Agents
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 = Agents(
    agents=[processor, analyzer],
    tasks=[process_task, analyze_task]
)