#AltDevBlogADay

private void ImportFromGoogle()
 
  {
 
      // Login/Password to GMail Account
 
      string userName = "username_goes_here";
 
      string password = "password_goes_here";
 
   
 
      // Name of spreadsheet and worksheet to access
 
      string spreadsheetName = "Example Spreadsheet";
 
      string worksheetName = "Example Worksheet";
 
   
 
      // Connect to google's service with login/password
 
      SpreadsheetsService service = new SpreadsheetsService( spreadsheetName );
 
      service.setUserCredentials( userName, password );
 
   
 
      // Query spreadsheets
 
      SpreadsheetQuery spreadsheetQuery = new SpreadsheetQuery();
 
      SpreadsheetFeed spreadsheetFeed = service.Query(spreadsheetQuery);
 
   
 
      // Loop over all spreadsheets
 
      foreach( SpreadsheetEntry spreadsheet in spreadsheetFeed.Entries )
 
      {
 
          // Check if this the spreadsheet we want
 
          if( !spreadsheetName.Equals(spreadsheet.Title.Text, StringComparison.OrdinalIgnoreCase) )
 
              continue;
 
   
 
          // Query worksheets
 
          AtomLink worksheetLink = spreadsheet.Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
 
          WorksheetQuery worksheetQuery = new WorksheetQuery(worksheetLink.HRef.ToString());
 
          WorksheetFeed worksheetFeed = service.Query(worksheetQuery);
 
   
 
          // Loop over worksheets
 
          foreach( WorksheetEntry worksheet in worksheetFeed.Entries )
 
          {
 
              // Check if this is the worksheet we want
 
              if( !worksheetName.Equals(worksheet.Title.Text, StringComparison.OrdinalIgnoreCase) )
 
                  continue;
 
   
 
              // Get cells
 
              AtomLink cellLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
 
              CellQuery cellQuery = new CellQuery(cellLink.HRef.ToString());
 
              CellFeed cellFeed = service.Query(cellQuery);
 
              AtomEntryCollection cellEntries = cellFeed.Entries;
 
   
 
              // Need to determine what column is what. Hardcoded for example.
 
              int devOffset = 0;
 
              int gameOffset = 1;
 
   
 
              // Loop over all entries finding the first entry on each row
 
              for( int i = 0; i < cellEntries.Count; ++i )
 
              {
 
                  // Continue if this entry is not the first entry of a row (and not the first row)
 
                  CellEntry baseEntry = cellEntries[i] as CellEntry;
 
                  if( baseEntry.Row == 1 || baseEntry.Column != 1 )
 
                      continue;
 
   
 
                  // Cell containing developer name
 
                  CellEntry devCell = cellEntries[i+devOffset] as CellEntry;
 
   
 
                  // Create a node for the tree view for this developer
 
                  TreeNode devNode = new TreeNode(devCell.Value);
 
   
 
                  // Loop over all games associated with this developer
 
                  int gameIndex = (i + gameOffset);
 
                  while( true )
 
                  {
 
                      // Get game cell, if it's on a new row we're done with this developer
 
                      CellEntry gameCell = cellEntries[gameIndex] as CellEntry;
 
                      if( gameCell.Row != devCell.Row )
 
                          break;
 
   
 
                      // Add game to developer tree node
 
                      devNode.Nodes.Add( new TreeNode(gameCell.Value) );
 
   
 
                      // Increment and validate index
 
                      ++gameIndex;
 
                      if( gameIndex >= cellEntries.Count )
 
                          break;
 
                  }
 
   
 
                  // Add developer node to list view
 
                  TV_Devs.Nodes.Add(devNode);
 
              }
 
          }
 
      }
 
  }