title: pandas read_excel select rows
body: <p>thanks to StackOverflow (so basically all of you) I've managed to solve almost all my issues regarding reading excel data to DataFrame, except one... My code goes like this:</p>
  
  <pre><code>df = pd.read_excel(
      fileName,
      sheetname=sheetName,
      header=None,
      skiprows=3,
      index_col=None,
      skip_footer=0,
      parse_cols='A:J,AB:CC,CE:DJ',
      na_values='')
  </code></pre>
  
  <p>The thing is that in excel files which I'm parsing last row of dataI want to load is every time on different position. The only way I can identify last row of data  which interest me is to look for word "SUMA" in first column of each sheet, and the last row I want to load to df will be n-1 row from the one containing "SUMA". Rows below SUMA also have some irrevelant (for me) information and there can by quite a lot of them so I want to avoid loading them.</p>