title: reading excel to a python data frame starting from row 5 and including headers
body: <p>how do I import excel data into a dataframe in python.</p>
  
  <p>Basically the current excel workbook runs some vba on opening which refreshes a pivot table and does some other stuff.</p>
  
  <p>Then I wish to import the results of the pivot table refresh into a dataframe in python for further analysis.</p>
  
  <pre><code>import xlrd
  
  wb = xlrd.open_workbook('C:\Users\cb\Machine_Learning\cMap_Joins.xlsm')
  
  #sheetnames
  print wb.sheet_names()
  
  #number of sheets
  print wb.nsheets
  </code></pre>
  
  <p>The refreshing and opening of the file works fine. But how do i select the data from the first sheet from say row 5 including header down to last record n.</p>