Tools Exposed

| Tool Name | Description | |-----------|-------------| | list_sheets | Returns an array of worksheet names available in the workbook. | | find_excel_files | Recursively finds all .xlsx files in directories. | | read_spreadsheet | Returns JSON representation of rows. Streams using worksheet.eachRow for memory efficiency. | | search_spreadsheet | Performs a filtered search based on a columnName and queryValue and returns matching rows. | | update_cell | Updates the local file and saves changes by setting a new cell value at a specific alphanumeric address (e.g. 'B2'). | | add_worksheet_with_data | Creates a new worksheet in an existing workbook and populates it with rows. | | create_new_workbook | Creates a brand new Excel workbook with initial sheet and data. NEW: Supports optional filePath with reference file directory. |

create_new_workbook - New Feature

You can now create a new workbook without specifying the full path. Instead, provide a reference file path and the new file will be created in the same directory:

Option 1: Direct Path (original way)

{
  "filePath": "/Users/user/new_file.xlsx",
  "columns": [{"header": "Name", "key": "name"}],
  "rows": [{"name": "John"}]
}