title: pandas Combine Excel Spreadsheets
body: <p>I have an Excel workbook with many tabs.
  Each tab has the same set of headers as all others.
  I want to combine all of the data from each tab into one data frame (without repeating the headers for each tab).</p>
  
  <p>So far, I've tried:</p>
  
  <pre><code>import pandas as pd
  xl = pd.ExcelFile('file.xlsx')
  df = xl.parse()
  </code></pre>
  
  <p>Can use something for the parse argument that will mean "all spreadsheets"?
  Or is this the wrong approach?</p>
  
  <p>Thanks in advance!</p>
  
  <p>Update: I tried:</p>
  
  <pre><code>a=xl.sheet_names
  b = pd.DataFrame()
  for i in a:
      b.append(xl.parse(i))
  b
  </code></pre>
  
  <p>But it's not "working".</p>