Excel

Comprehensive guide to the Excel node in StackAI: Learn how to automate spreadsheet tasks, write data, and integrate Excel with your workflows.

How to Use the Excel Node

To use the Excel node, simply add it to your StackAI workflow and configure it to perform actions such as writing data to a spreadsheet. You can connect it to other nodes (like LLMs, input nodes, or data sources) to automate the flow of information into your Excel files. The node supports secure authentication via connection IDs, ensuring your data remains protected. Alternatively, you can also add Excel as a tool for your LLM to use.

---

Example of Usage

Suppose you want to automatically log survey responses from a form into an Excel spreadsheet stored in SharePoint. You can connect the input node (collecting responses) to the Excel node, which then writes each new entry into the designated spreadsheet, eliminating manual data entry.

---

Available Actions for the Excel Node

Currently, we support 17 different actions for the Excel node in StackAI:

Action	Description
Write to Sheet	Automatically writes data to a specified Excel sheet in SharePoint or OneDrive.
Create Workbook	Create a new Excel workbook in a specified SharePoint site or OneDrive location. You can specify the workbook name and optional folder path.
List Workbooks	Retrieve a list of all Excel workbooks available in a SharePoint site or OneDrive. Returns workbook details and count.
Create Sheet	Create a new worksheet/tab within an existing workbook in SharePoint or OneDrive.
Delete Sheet	Completely remove a worksheet from a workbook.
Clear Sheet	Remove all data from a worksheet while keeping the sheet itself. Optionally clear only a specific range.
List Sheets	Retrieve a list of all worksheets in a workbook, including sheet count.
Read from Sheet	Read data from a worksheet.
Update Cell	Update a single cell with a new value (text, number, formula, or clear it).
Get Sheet by ID	Find a specific worksheet by its unique ID or by name. Returns worksheet details including position and visibility.
Rename Sheet	Change the name of an existing worksheet (find by name or index).
Create Table	Create a new formatted Excel table within a worksheet. Specify data, starting cell, and optional table range.
Add Data to Table	Append new rows of data to an existing Excel table.
Update Row	Update an existing row with new values at a specified row index.
Find Row	Search for rows containing a specific value. Supports column filtering and case-sensitive search.
Get Cells in Range	Read cell value(s) from a specific range (single cell, rectangular range, entire column, or row).
Get Row by Index	Get a specific row by its row number from an Excel worksheet (1-based). Specify column range (e.g., A to Z).

Example: Write to Sheet

Description: Automatically writes data to a specified Excel sheet in SharePoint or OneDrive.

Connect Excel

Establish a new connection or using an existing connection to SharePoint or OneDrive.

Inputs

Name	Description	Required	Input Type
Site	Select the site from your connection (OneDrive or SharePoint)	Yes	Select from dropdown
Workbook	Select the Excel workbook	Yes	Select from dropdown or search
Sheet	Enter the specific sheet name in the workbook	Yes	Select from dropdown
Values	Enter the values to write to the sheet (JSON)	Yes	Enter manually or use prior input nodes
Target Range	Starting cell or the explicit range to write data (e.g., A1:D10)	Yes	Enter manually or use prior input nodes
Formulas	2D array of formulas matching data dimensions	No	Enter manually or use prior input nodes

Example Input:

{
    "site_id": "abc123",
    "sheet_name": "Test",
    "workbook_url": "Example",
    "data": "[[\"test 1\",\"1\"],[\"test 2\",\"2\"]]",
    "target_range": "A1:B2",
    "connection_id": "your-connection-id-here",
    "connector_type_id": "excel_sharepoint_oauth2"
 }

Outputs

Name	Description
Status	Status of the operation
Message	Message about the operation

Example Output:

{
    "status": "Success",
    "message": "Successfully wrote 2 row(s) x 2 column(s) to range A1:B2 in sheet 'Test'"
  }

---

Best Practices

• Always ensure your connection ID is valid and has the necessary permissions to access the target Excel file.

• Validate your data structure before writing to avoid errors.

• Use dynamic node references (e.g., {in-0}) to automate data flow from other nodes.

---

Summary

The Excel node in StackAI is a powerful tool for automating spreadsheet operations in SharePoint. By leveraging its write capabilities, you can streamline data management, reduce manual work, and enhance collaboration across your team.