title: Not able to read excel file which I created through open function?
body: <p>I created one excel file and wrote something in it. I am trying to read that file through pandas - dataframe, but I am getting error </p>
  
  <pre><code>XLRDError: Unsupported format, or corrupt file: Expected BOF record
  </code></pre>
  
  <p>Code -</p>
  
  <pre><code>import pandas as pd
  a = open("D:\\Joseph\\abcsaa.xlsx","a")
  a.write("Hello all")
  p = pd.read_excel("D:\\Joseph\\abcsaa.xlsx")
  p
  </code></pre>
  
  <p>Thanks for the answers. I need to store tick data in a excel and then read it through dataframe. </p>
  
  <p>What is the use of open function in python for excel file if I have to use other modules for this ?</p>