ODBC guide

Read Excel worksheet (specified range)

Reads an Excel file from a specified cell range. To automatically read without a cell range, use the get_excel_worksheet_autodetect endpoint.

SELECT * FROM get_excel_worksheet
WITH (
     -- Drive (SharePoint Document Library)
		DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXX'
	    
		,FileId='root:/myfolder/dump.xlsx:' --Path must end with colon
  	    --,FileId='01SUOJPKECYDDVFXXXXXXXXXXXXXXXXXX'  --By Id (preferred)
		
	   ,SheetId='Sheet1' --Id or Name
     --,SheetId='{00000000-0001-0000-0000-000000000000}' --Using ID is good idea if Sheet ever renamed (Id doesnt change)	   
	   ,Range='A1:K10000'
	   ,ArrayTransEnableCustomColumns='True' --set this to False if No header in first row
	   )
--DriveId can be retrieved by selecting from 'Drives' table.
--FileId can be retrieved by selecting from 'list_files' endpoint.
--SheetId can be retrieved by downloading Excel file and discovering what sheets exist or by selecting from 'list_excel_worksheets' endpoint.
--Range should be set to Excel-type of range where data is located.