title: Google sheet API multiple ranges parsing
body: <p>I am trying to play around with Google Spreadsheet API I just incorporated with my App. lets say I have this worksheet</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1TfRWRh0l09cxZ4HqwYWhRiBK4Lll3Jvj0XHpO-KEK2E/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1TfRWRh0l09cxZ4HqwYWhRiBK4Lll3Jvj0XHpO-KEK2E/edit#gid=0</a></p>
  
  <p>and I want to parse both data ranges into 1 output table of: Name, Age, Hobby, Occupation, School, and Gender. How would I write the code to differentiate between data range 1 and 2?</p>
  
  <p>Here is the code:</p>
  
  <pre><code>private List&lt;String&gt; getDataFromApi() throws IOException {
      String spreadsheetId = "1TfRWRh0l09cxZ4HqwYWhRiBK4Lll3Jvj0XHpO-KEK2E";
      String range = "test!A3:D6,B10:C13";
      List&lt;String&gt; results = new ArrayList&lt;String&gt;();
      ValueRange response = this.mService.spreadsheets().values()
              .get(spreadsheetId, range)
              .execute();
      List&lt;List&lt;Object&gt;&gt; values = response.getValues();
      if (values != null) {
          results.add("Name, Age, Hobby, Occupation, School, Gender");
          for (List row : values) {
              results.add(row.get(0) + ", " + row.get(1) + ", " + row.get(2) + ", " + row.get(3)); //then i'm stuck//
          }
      }
      return results;
  }
  </code></pre>
  
  <p>Many thanks!</p>