SharePoint Online Connector
SharePoint Online Connector Help
Version 12
ZappySys Logo File Version: v12
Supported Engine: 9

EndPoint Read Excel Worksheet (Specific Range)


Name

get_excel_worksheet

Description

Use this endpoint to read data from excel worksheets with address range e.g. A1:D100. If you want dynamic range or unsure about end row then use the other endpoint with Auto Detect feature [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
Range Range YES

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.