title: Pandas read_excel multiple tables from 1 sheet with multiindex headers
body: <p>I needed to read few tables from manualy made excel. Here I found a solution:</p>
  
  <p><a href="https://stackoverflow.com/questions/43367805/pandas-read-excel-multiple-tables-on-the-same-sheet">pandas read_excel multiple tables on the same sheet</a></p>
  
  <p>But it didn't fix my whole problem, because some of my tables has multiindex column names. I tried this way:<a href="https://i.stack.imgur.com/11upZ.png" rel="nofollow noreferrer">excel example</a></p>
  
  <pre><code>nrows = excel_file.book.sheet_by_index(0).nrows  
  table2 = excel_file.parse(0, skiprows=6, skip_footer=nrows - 11, header=[0,1,2]).dropna(axis=1, how='all')
  </code></pre>
  
  <p>and in this cases I have "ValueError: Length of new names must be 1, got 3"</p>
  
  <p>I have found that if my excel file will look like this:<a href="https://i.stack.imgur.com/1Dr4X.png" rel="nofollow noreferrer">modified excel file</a>
  (without columns in other tables that are longer than table i read) then it works! How can I solve this problem?</p>