SharePoint Online Connector
Documentation
Version: 14
Documentation

EndPoint Read Excel Worksheet (Auto Detect Range)


Name

get_excel_worksheet_autodetect

Description

Use this endpoint to read data from a Sheet without supplying address range (e.g. A1:D100). This endpoint auto detects address range based on used cells in a sheet. [API Help]

Parameters

Parameter Label Required Options Description
SiteId SiteId NO Specify a site
DriveId DriveId YES Specify a drive Id
FileId FileId YES Specify a file id
SheetId SheetId YES Specify a sheet name
AutoDetectByValue AutoDetectByValue NO
Option Value
true true
false false
Auto detect cell range based on values only and do not consider cell formatting (for empty values) to detect the range.

Output Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.