Excel Read Sheet

Reads all data from a named worksheet in a SharePoint-hosted Excel file and stores the result as a two-dimensional array.

Purpose

Use this task to import worksheet data from an Excel file stored in SharePoint Online into the workflow for further processing. The full path to the file and the target worksheet name are required. The task uses a Microsoft third-party account to authenticate with the Microsoft Graph API and retrieve the sheet contents. The resulting data is available to downstream tasks as a two-dimensional array variable.

Inputs

Field	Type	Required	Description
Sharepoint Path to File	Text	Yes	The full SharePoint URL to the Excel file, including the filename. For example: https://myco.sharepoint.com/sites/YourSiteName/Shared Documents/YourFolderName/YourFileName.xlsx.
Worksheet Name	Text	Yes	The name of the worksheet tab within the Excel file to read. For example: Sheet1.

Outputs

Name	Description
ExcelRange	A two-dimensional array containing all rows and columns of data from the specified worksheet.