ODBC guide

Read Excel file worksheets

Gets the list of worksheets in an Excel file. Supply DriveId and FileId (or file path).

SELECT * FROM list_excel_worksheets
WITH (
      DriveId='me'
    --OR-- Use Shared Drive Id or other User's Drive Id
    -- DriveId='b!GtLN726LE0eXXXXXXXXXXXX'
	  
	   ,FileId='root:/MyFolder/Book1.xlsx:' --Path must end with colon
		
	 --OR Use File Id
  	 --,FileId='01SUOJPFXXXXXXXXXXXXXXXXXX'
	)
--DriveId can be retrieved by selecting from 'list_drives' endpoint.
--FileId can be retrieved by selecting from 'list_excel_files' endpoint.