Excel Read Range

The Excel Read Range node allows you to extract data from a specific worksheet in an Excel file stored in SharePoint Online. This node uses the Microsoft Graph API to connect to the file and retrieve the data as a two-dimensional array.

---

📌 Purpose

Use this node to read the entire contents of a worksheet (excluding defined range filtering) and store the results in a variable for use in downstream workflow steps.

---

⚙️ Configuration

This node requires two user inputs:

Sharepoint Path to File

• Type: Text
• Description: Full SharePoint-relative path to the Excel file, including the filename.
• Example: /Shared Documents/Reports/SalesReport.xlsx
• Required: ✅

Worksheet Name

• Type: Text
• Description: The name of the worksheet within the Excel file to read from.
• Example: Sheet1
• Required: ✅

📝 Note: The current implementation reads the entire sheet. Although a Range Address field is present in the backend code, it is not active or required in the UI.

---

📤 Output

The node outputs a two-dimensional array of the worksheet content into a variable named:

ExcelRange

• Type: Array of Arrays (object[][])
• Description: Contains all the rows and columns of data from the worksheet.
• Usage: This can be accessed in subsequent nodes using {ExcelRange}.

---

🔐 Service Account

This node requires a valid Microsoft 365 service account token:

• Service Account Type: Microsoft Graph API
• Token ID Field: ThirdParty-Microsoft

If no valid token is found or configured, the node will fail with the message:
"Required Service Accounts not found"

---

✅ Success Criteria

The task is marked as Completed when:

• The SharePoint path and worksheet name are valid
• The Excel file and sheet are successfully accessed
• Data is returned from the Graph API

---

❌ Failure Conditions

The task may fail under the following conditions:

• Invalid or missing SharePoint path, worksheet name, or file
• Invalid Microsoft service account token
• Failure to resolve SharePoint locations
• Failure to read Excel data

Error messages will be returned via taskMessage.

---

🛠 Backend Notes

• Uses ExcelGraphService.GetSheetDataAsync(...) to fetch data
• Removes the input fields from the taskParameters.data object once processed
• Adds the Excel data as ExcelRange for downstream use
• A future enhancement could re-enable Range Address support if needed

---