title: Reading Excel file Using PySpark: Failed to find data source: com.crealytics.spark.excel
body: <p>I'm trying to read an excel file with spark using jupyter in vscode,with java version of 1.8.0_311 (Oracle Corporation), and scala version of version 2.12.15.</p>
  <p>Here is the code below:</p>
  <pre><code># import necessary library 
  import pandas as pd 
  from pyspark.sql.types import StructType
  
  # entry point for spark's functionality 
  from pyspark import SparkContext, SparkConf, SQLContext 
      
  configure = SparkConf().setAppName(&quot;name&quot;).setMaster(&quot;local&quot;)
  sc = SparkContext(conf= configure)
  sql = SQLContext(sc)
  
  # entry point for spark's dataframes
  from pyspark.sql import SparkSession
  
  spark = SparkSession \
      .builder \
      .master(&quot;local&quot;) \
      .appName(&quot;pharmacy scraper&quot;) \
      .config(&quot;spark.jars.packages&quot;, &quot;com.crealytics:spark-excel_2.11:0.12.2&quot;) \
      .getOrCreate()
  
  # reading excel file 
  df_generika = spark.read.format(&quot;com.crealytics.spark.excel&quot;).option(&quot;useHeader&quot;, &quot;true&quot;).option(&quot;inferSchema&quot;, &quot;true&quot;).option(&quot;dataAddress&quot;, &quot;Sheet1&quot;).load(&quot;./../data/raw-data/generika.xlsx&quot;)
  </code></pre>
  <p>Unfortunately, it produces an error</p>
  <pre><code>Py4JJavaError: An error occurred while calling o36.load.
  : java.lang.ClassNotFoundException: 
  Failed to find data source: com.crealytics.spark.excel. Please find packages at
  http://spark.apache.org/third-party-projects.html
  </code></pre>