title: Reading Excel file from Azure Databricks
body: <p>Am trying to ready Excel file (<code>.xlsx</code>) from Azure Databricks, file is in ADLS Gen 2.</p>
  <p>Example:</p>
  <pre><code>srcPathforParquet = &quot;wasbs://hyxxxx@xxxxdatalakedev.blob.core.windows.net//1_Raw//abc.parquet&quot;
  srcPathforExcel = &quot;wasbs://hyxxxx@xxxxdatalakedev.blob.core.windows.net//1_Raw//src.xlsx&quot;
  </code></pre>
  <p>Reading parquet file from the path works fine.</p>
  <pre><code>srcparquetDF = spark.read.parquet(srcPathforParquet )
  </code></pre>
  <p>Reading excel file from the path throw error: <strong>No such file or directory</strong></p>
  <pre><code>srcexcelDF = pd.read_excel(srcPathforExcel , keep_default_na=False, na_values=[''])
  </code></pre>