title: Reading Excel file to Python fails due to number formatted as text
body: <p>I have a ton of Excel files that each have a column where numbers are formatted as text. Excel gives the error "the number in this cell is formatted as text or preceded by an apostrophe" - see the third column where the cells have a green triangle.</p>
  
  <p><a href="https://i.stack.imgur.com/oF4Kw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oF4Kw.png" alt="enter image description here"></a></p>
  
  <p>My goal is to open all of these files in Pandas <strong>without</strong> having to manually open each of them and convert the column to number. However, pd.read_excel() fails with the following <code>xlrd</code> error:</p>
  
  <pre><code>XLRDError: ZIP file contents not a known type of workbook
  </code></pre>
  
  <p>Unsurprisingly when I use <code>xlrd</code> directly: <code>wb = xlrd.open_workbook(filename)</code> I get the same error.</p>
  
  <p>I also tried openpyxl: <code>wb = openpyxl.load_workbook(filename)</code>, and it gives me this:</p>
  
  <pre><code>KeyError: "There is no item named 'xl/_rels/workbook.xml.rels' in the archive"
  </code></pre>
  
  <p>I confirmed that the file is openable by both pandas (xlrd) and openpyxl if I manually convert the column to number in excel and re-save the workbook.</p>
  
  <p>Does anyone have any ideas?</p>