@Dhusanth Thangavadivel​  This can be done by using the jdbc connector and following the steps mentioned in the document

https://www.cdata.com/kb/tech/sharepoint-jdbc-azure-databricks.rst

listing the file is not possible according to the MSFT doc: https://docs.microsoft.com/en-us/answers/questions/537148/how-can-i-read-share-point-excel-files-in-...

and in the second workaround of the document you can see, you can load SharePoint data as a dataframe using the CData JDBC Driver and the connection information.