ODBC guide

Read Excel data as formatted text or formula

Gets Excel data as formatted text instead of raw values. Use the Filter parameter (e.g. $.text[*]) to return datetime values as formatted text rather than serial numbers.

SELECT * FROM get_excel_worksheet_autodetect
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'
	   
	    ,SheetId='Sheet1'
	  --OR-- Use Sheet ID - Using ID is good idea if Sheet ever renamed (Id doesnt change)
	  --,SheetId='{00000000-0001-0000-0000-000000000000}'
	  
	    ,Filter='$.text[*]' --this returns date as formatted value (i.e. 1/1/2020 rather than 43831)  
		--,Filter='$.formulas[*]' --this returns formula cells only (returns actual formula expression or null if no formula)
		)
--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.