Excel Processor Pack

★Trustedv1.0.0MIT✔Verified88

by AgentNode · published 22 days ago · toolpack

Create, read, and manipulate Excel spreadsheets with formulas.

Generate XLSX files with formulas, formatting, charts, and pivot tables. Read and analyze existing spreadsheets. Uses openpyxl.

langchaincrewaigeneric

Quick Start

bash
agentnode install excel-processor-pack

Usage

From package
python
from excel_processor_pack.tool import run

result = run(
    action="process_xlsx",
    operation="create",
    sheets=[
        {
            "name": "Q1 Sales",
            "headers": ["Rep", "Region", "Jan", "Feb", "Mar", "Total"],
            "rows": [
                ["Alice Chen", "Northeast", 42000, 38500, 51000, "=SUM(C2:E2)"],
                ["Bob Patel", "Southeast", 35000, 41200, 39800, "=SUM(C3:E3)"],
                ["Carol Wu", "West", 48000, 52000, 47500, "=SUM(C4:E4)"],
                ["Total", "", "=SUM(C2:C4)", "=SUM(D2:D4)", "=SUM(E2:E4)", "=SUM(F2:F4)"]
            ],
            "formatting": {
                "header_bold": True,
                "currency_columns": ["C", "D", "E", "F"],
                "total_row_style": "bold_border_top"
            }
        }
    ],
    output_path="/tmp/q1_sales_report.xlsx"
)

print(f"Spreadsheet created: {result['output_path']}")
print(f"Sheets: {result['sheet_count']}")
print(f"File size: {result['file_size_kb']:.1f} KB")

Verification

high confidence88/100✔ Verified
smokeReturned valid result
+25/25
testsAuto-generated tests only
+8/15
importAll tools imported successfully
+15/15
installInstalled in 1.8s
+15/15
contractAll contract checks passed
+10/10
warningsNo warnings
0/0
determinismOutput consistency check
+5/5
reliability3/3 runs passed
+10/10

Package installs and imports correctly. runtime checks passed.

✔install1.8s
✔import498ms
✔smoke278ms
✔tests1.3s

This package was executed and validated by AgentNode before listing. Install, import, and runtime checks passed.

Python 3.12.3ffmpegpopplertesseractuv

Last verified 18d ago· Runner v2.0.0

Use this when you need to...

  • ›Generate monthly expense reports as formatted XLSX with formulas
  • ›Parse uploaded Excel timesheets and aggregate hours by project
  • ›Create pivot tables from raw sales transaction spreadsheets
  • ›Add conditional formatting and charts to financial models
  • ›Merge multiple Excel workbooks into a consolidated summary sheet

README

Excel Processor Pack

Create, read, and manipulate Excel spreadsheets with formulas. Generate XLSX files with formulas, formatting, charts, and pivot tables.

Quick Start

agentnode install excel-processor-pack

from excel_processor_pack.tool import run

result = run(
    action="process_xlsx",
    operation="create",
    sheets=[{"name": "Sheet1", "headers": ["Name", "Score"], "rows": [["Alice", 95], ["Bob", 87]]}],
    output_path="/tmp/output.xlsx"
)

Usage

Read and Inspect a Spreadsheet

result = run(action="process_xlsx", operation="read", file_path="/data/budget.xlsx", sheet="2025")
print(f"Columns: {result['headers']}")
for row in result["rows"][:5]:
    print(row)

Add Formulas and Formatting

result = run(
    action="process_xlsx",
    operation="create",
    sheets=[{"name": "Budget", "headers": ["Item", "Cost", "Tax", "Total"],
             "rows": [["Server", 1200, "=B2*0.08", "=B2+C2"]],
             "formatting": {"currency_columns": ["B", "C", "D"]}}],
    output_path="/tmp/budget.xlsx"
)

Generate a Chart

result = run(
    action="process_xlsx",
    operation="add_chart",
    file_path="/data/metrics.xlsx",
    chart_type="line",
    data_range="A1:D13",
    title="Monthly Metrics",
    output_path="/tmp/metrics_chart.xlsx"
)

API Reference

CapabilityDescription
process_xlsxCreate, read, transform, and chart Excel workbooks

Operations: create, read, pivot, add_chart, merge_workbooks, apply_formatting

Features: Formulas, conditional formatting, pivot tables, bar/line/pie charts, multi-sheet workbooks

License

MIT

Version History

v1.0.0latestverified
3/16/2026

Capabilities

excel_processingprocess_xlsxtool

Permissions

This package declares the following access levels. Review before installing.

Networknone
Filesystemtemp
Code Executionnone
Data Accessinput_only
User Approvalnever
bash
agentnode install excel-processor-pack

Files (3)

License

MIT

Stats

Downloads0
Installs0
Versionv1.0.0
Published3/16/2026
Channelstable
Typetoolpack
Entrypointexcel_processor_pack.tool

Compatibility

Frameworks

langchaincrewaigeneric

Runtime

python

Python Version

>=3.10

Trust & Security

Publisher★Trusted
SignatureNone
ProvenanceNone
Security Issues0

Publisher

A

AgentNode

@agentnode

Report an issue with this package