Excel Spreadsheet Tool

This skill enables working with Microsoft Excel spreadsheets using Node.js tools.

Capabilities

• •Read data from existing Excel files and extract tabular data
• •Create new workbooks with multiple worksheets
• •Write data to cells and ranges
• •Apply formulas and calculations (SUM, AVERAGE, etc.)
• •Format cells with colors, borders, fonts, and auto-sizing
• •Analyze data with column statistics (sum, average, min, max)
• •Update specific cells in existing spreadsheets

When to Use

Invoke this skill when the user:

• •Mentions Excel files, spreadsheets, .xlsx files, or tabular data
• •Asks to create, read, or modify spreadsheet data
• •Needs to perform calculations, formulas, or data analysis
• •Wants to format data in rows and columns
• •Asks about data visualization or charts

How to Use

The Excel tool is implemented at src/tools/excel-tool.ts. Invoke using the Bash tool:

Reading a Spreadsheet

ts-node src/tools/excel-tool.ts read "/path/to/file.xlsx" "SheetName"

Creating a Spreadsheet

ts-node src/tools/excel-tool.ts create "/path/to/new.xlsx" '[{"name":"Sheet1","data":[["A1","B1"],["A2","B2"]],"headers":["Column1","Column2"]}]'

Getting Column Statistics

ts-node src/tools/excel-tool.ts stats "/path/to/file.xlsx" "Sheet1" "A"

JSON Structure for Creating Spreadsheets

[
  {
    "name": "Sheet1",
    "headers": ["Name", "Value", "Total"],
    "data": [
      ["Item 1", 100, 200],
      ["Item 2", 150, 300]
    ],
    "formulas": [
      {"cell": "C3", "formula": "SUM(B2:B3)"}
    ]
  }
]

Implementation

Uses the exceljs npm library for comprehensive Excel file manipulation.