title: How to read rows after empty row in the Google spreadsheet?
body: <p>I'm using <a href="http://code.google.com/apis/gdata/articles/python_client_lib.html" rel="nofollow">gdata-python-client</a> to read data from a Google spreadsheet. My code for reading rows is as follows:</p>
  
  <pre><code>import gdata.speadsheet.text_db
  
  gd_client = gdata.spreadsheet.text_db.DatabaseClient(
                       username=setting['account_name'],
                       password=setting['account_pass'])
  
  xls_db = gd_client.GetDatabases(spreadsheet_key=setting['spreadsheet_id'])
  first_sheet = xls_db[0].GetTables()[0]
  entries = first_sheet.GetRecords(1, 200)
  </code></pre>
  
  <p>Let's say, the spreadsheet has 160 rows and the 12<sup>th</sup> row is empty. When I try to read all 160 rows using the above code, it only reads the first 11 rows (that is, until it gets the empty 12<sup>th</sup> row). If the spreadsheet doesn't have any empty rows, the code reads all 160 rows.</p>
  
  <p>When I try to read the next rows from the empty row, it returns nothing. for example:</p>
  
  <pre><code>entries = first_sheet.GetRecords(50, 55) # entries is None
  </code></pre>
  
  <p>How can I read all the rows from a Google spreadsheet which contains empty rows.</p>
  
  <p>Any help would be appreciated.</p>