Method 1: Using "com.crealytics.spark.excel" package, how do I import the package?

Method 2: Using pandas I tried the possible paths, but file not found it shows, nor while uploading the xls/xlsx file it shows options for importing the dataframe.

Help is appreciated
Thanks