ODBC guide

List Excel worksheets

Gets a list of worksheets in an Excel file.

SELECT * FROM list_excel_worksheets
WITH (
	-- Drive (SharePoint Document Library)
	DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXXXXX'
	
	,FileId='root:/myfolder/dump.xlsx:' --Path must end with colon
    --,FileId='01SUOJPKECYDDVFXXXXXXXXXXXXXXXXXX'  --By Id (preferred)
		
	)
--DriveId can be retrieved by selecting from 'Drives' table.
--FileId can be retrieved by selecting from 'list_files' endpoint.