title: Expected BOF record for XLRD when first line is redundant
body: <p>I came across the problem when I tried to use xlrd to import an .xls file and create dataframe using python.</p>
  
  <p>Here is my file format:</p>
  
  <p><a href="https://i.stack.imgur.com/qVEKQ.png" rel="nofollow noreferrer">xls file format</a></p>
  
  <p>When I run:</p>
  
  <pre><code>import os
  import pandas as pd
  import xlrd
  
  for filename in os.listdir("."):
      if filename.startswith("report_1"):
         df = pd.read_excel(filename)
  </code></pre>
  
  <p>It's showing "XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'Report g'"
  I am pretty sure nothing wrong with xlrd (version 1.0.0) because when I remove the first row, dataframe can be created. 
  Wonder if there is any way that i can load the original file format? </p>