title: Pandas.read_excel throws "TypeError: list indices must be integers, not str"
body: <p>I am trying to read in an excel file with the exact same parameters and setup as countless files before. However this one is refused by Pandas.</p>
  
  <p>Sheetid and headerrow are 0 in this case. The file is of type xlsx. I tried saving as xls, but it didn't help.</p>
  
  <p>This is also the row which raises the error:</p>
  
  <pre><code>inputframe = pd.read_excel(filename, sheetname=sheetid, header=headerrow)
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>in _parse_excel
  data[header] = _trim_excel_header(data[header])
  TypeError: list indices must be integers, not str
  </code></pre>
  
  <p>Here is a screenshot of the header and first few rows of the excel file in question:</p>
  
  <p><a href="https://i.stack.imgur.com/eL80O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eL80O.png" alt="Excel file header and first rows"></a></p>
  
  <p>I know that there are some empty cells in the file but that hasn't caused any problems in the past. Also I am probably not allowed to share the whole file with you for a more detailled analysis. Have to ask my boss first.</p>