DemoEsbSpread.java

package org;

import java.net.URL;
import java.util.List;

import com.google.gdata.client.spreadsheet.*;
import com.google.gdata.data.*;
import com.google.gdata.data.spreadsheet.*;
import com.google.gdata.util.*;


public class Main {

	/**
	 * @param args
	 * @throws Exception 
	 */
	public static void main(String[] args) throws Exception {
		
		SpreadsheetService myService = new SpreadsheetService("JBossEsb-GoogleDocs-1");
		
		myService.setUserCredentials("jbossesb@facilitait.com.br", "#########");
		
		URL metafeedUrl = new URL("http://spreadsheets.google.com/feeds/spreadsheets/private/full");
		
		SpreadsheetFeed feed = myService.getFeed(metafeedUrl, SpreadsheetFeed.class);
		
		List<SpreadsheetEntry> spreadsheets = feed.getEntries();
		
		SpreadsheetEntry entry =  null ; 
		
		for (int i = 0; i < spreadsheets.size(); i++) {
			
		  entry = spreadsheets.get(i);
		  
		  if (entry.getTitle().getPlainText().equalsIgnoreCase("SKILLS-3-to-8")) {
		     
			  List<WorksheetEntry> worksheets = entry.getWorksheets();
			  
			  for (int j = 0; j < worksheets.size(); j++) { 
				  
				  WorksheetEntry worksheet = worksheets.get(j);
				  
				  URL cellFeedUrl = worksheet.getCellFeedUrl();
				  
				  CellFeed cfeed = myService.getFeed(cellFeedUrl, CellFeed.class);
				  
				  for (CellEntry cell : cfeed.getEntries()) {
					  
					  String value = cell.getCell().getInputValue();
					  
					  System.out.println("" + cell.getPlainTextContent()  + "\n");
					  
				  }
				  
				  
			  }
			  
			  
		  
		  }
		  
	   
		}
		
	
		
		

	}

}