OneDrive Connector
Documentation
Version: 5
Documentation
Home » API Integration Hub » OneDrive Connector » EndPoints > Read Excel Worksheet (Auto Detect Range)

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
DriveId DriveId YES Specify a drive Id to search items in
FileId FileId YES Specify a file id
SheetId SheetId YES Specify a sheet id or 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.