title: Can't read .xlsx file on Azure Databricks
body: <p>I'm on Azure databricks notebooks using Python, and I'm having trouble reading an excel file and putting it in a spark dataframe.</p>
  
  <p>I saw that there were topics of the same problems, but they don't seem to work for me.</p>
  
  <p>I tried the following solution:</p>
  
  <p><a href="https://sauget-ch.fr/2019/06/databricks-charger-des-fichiers-excel-at-scale/" rel="nofollow noreferrer">https://sauget-ch.fr/2019/06/databricks-charger-des-fichiers-excel-at-scale/</a></p>
  
  <p>I did add the credentials to access my files on Azure Data Lake.</p>
  
  <p>After installing all the libraries I needed, I'm doing this code : </p>
  
  <pre class="lang-py prettyprint-override"><code>import xlrd
  import azure.datalake.store
  
  filePathBsp = projectFullPath + "BalanceShipmentPlan_20190724_19h31m37s.xlsx";
  bspDf = pd.read_excel(AzureDLFileSystem.open(filePathBsp))
  </code></pre>
  
  <p>There, I use:</p>
  
  <pre><code>"AzureDLFileSystem.open" 
  </code></pre>
  
  <p>to get the file in Azure Data Lake because:</p>
  
  <pre><code>"pd.read_excel" 
  </code></pre>
  
  <p>doesn't let me get my file to the Lake.</p>
  
  <p>The problem is, it gives me this error : </p>
  
  <pre><code>TypeError: open() missing 1 required positional argument: 'path'
  </code></pre>
  
  <p>I'm sure I can access this file because when I try: </p>
  
  <pre><code>spark.read.csv(filePathBsp) 
  </code></pre>
  
  <p>he can find my file.</p>
  
  <p>Any ideas?</p>