title: error in reading excel files with crealytics plugin
body: <p>All,</p>
  <p>I'm trying to load excel file based on the link  -  <a href="https://github.com/crealytics/spark-excel/blob/main/docs/spark_excel_examples.ipynb" rel="nofollow noreferrer">https://github.com/crealytics/spark-excel/blob/main/docs/spark_excel_examples.ipynb</a>.</p>
  <p>Ours is a SQLServer BDC with the HDFS being our local storage for storing files/result set ... etc.</p>
  <pre><code>from pyspark.sql import SparkSession
  from pyspark.sql.functions import input_file_name
  
  # Assembly or download spark-excel and its dependencies
  jars = [
      &quot;hdfs://modules/jar/spark-excel_2.11-0.13.0.jar&quot;,
      &quot;hdfs://modules/jar/poi-ooxml-schemas-4.1.2.jar&quot;,
      &quot;hdfs://modules/jar/commons-collections4-4.4.jar&quot;,
      &quot;hdfs://modules/jar/xmlbeans-3.1.0.jar&quot;
  ]
  
  spark = SparkSession \
      .builder \
      .appName(&quot;Python Spark SQL basic example&quot;) \
      .config(&quot;spark.jars&quot;, &quot;,&quot;.join(jars)) \
      .getOrCreate()
  
  
  df = spark.read.format(&quot;com.crealytics.spark.excel&quot;) \
     .option(&quot;header&quot;, True) \
     .option(&quot;inferSchema&quot;, True) \
     .load(f&quot;hdfs://test/users.xlsx&quot;) \
     .withColumn(&quot;file_name&quot;, input_file_name())
  </code></pre>
  <p>But I'm getting the below error. <strong>What am I doing wrong?</strong></p>
  <blockquote>
  <p>An error was encountered: An error occurred while calling o89.load. :
  java.lang.ClassNotFoundException: Failed to find data source:
  com.crealytics.spark.excel. Please find packages at
  <a href="http://spark.apache.org/third-party-projects.html" rel="nofollow noreferrer">http://spark.apache.org/third-party-projects.html</a>
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:692)
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSourceV2(DataSource.scala:746)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:265)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:239)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
  at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  at py4j.Gateway.invoke(Gateway.java:282)
  at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
  at py4j.commands.CallCommand.execute(CallCommand.java:79)
  at py4j.GatewayConnection.run(GatewayConnection.java:238)
  at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.ClassNotFoundException:
  com.crealytics.spark.excel.DefaultSource
  at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:419)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:352)
  at org.apache.spark.sql.execution.datasources.DataSource$.$anonfun$lookupDataSource$5(DataSource.scala:666)
  at scala.util.Try$.apply(Try.scala:213)
  at org.apache.spark.sql.execution.datasources.DataSource$.$anonfun$lookupDataSource$4(DataSource.scala:666)
  at scala.util.Failure.orElse(Try.scala:224)
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:666)
  ... 14 more</p>
  <p>Traceback (most recent call last):   File
  &quot;/opt/spark/python/lib/pyspark.zip/pyspark/sql/readwriter.py&quot;, line
  204, in load
  return self._df(self._jreader.load(path))   File &quot;/opt/spark/python/lib/py4j-src.zip/py4j/java_gateway.py&quot;, line 1304,
  in <strong>call</strong>
  return_value = get_return_value(   File &quot;/opt/spark/python/lib/pyspark.zip/pyspark/sql/utils.py&quot;, line 111, in
  deco
  return f(*a, **kw)   File &quot;/opt/spark/python/lib/py4j-src.zip/py4j/protocol.py&quot;, line 326, in
  get_return_value
  raise Py4JJavaError( py4j.protocol.Py4JJavaError: An error occurred while calling o89.load. : java.lang.ClassNotFoundException:
  Failed to find data source: com.crealytics.spark.excel. Please find
  packages at <a href="http://spark.apache.org/third-party-projects.html" rel="nofollow noreferrer">http://spark.apache.org/third-party-projects.html</a>
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:692)
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSourceV2(DataSource.scala:746)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:265)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:239)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
  at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
  at py4j.Gateway.invoke(Gateway.java:282)
  at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
  at py4j.commands.CallCommand.execute(CallCommand.java:79)
  at py4j.GatewayConnection.run(GatewayConnection.java:238)
  at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.ClassNotFoundException:
  com.crealytics.spark.excel.DefaultSource
  at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:419)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:352)
  at org.apache.spark.sql.execution.datasources.DataSource$.$anonfun$lookupDataSource$5(DataSource.scala:666)
  at scala.util.Try$.apply(Try.scala:213)
  at org.apache.spark.sql.execution.datasources.DataSource$.$anonfun$lookupDataSource$4(DataSource.scala:666)
  at scala.util.Failure.orElse(Try.scala:224)
  at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(DataSource.scala:666)
  ... 14 more</p>
  </blockquote>