I am writing a Java program to fetch Google Spreadsheet Document contents
from a user id.
I am able to login and get details of the spreadsheet I require.
But if i am trying to get the details of worksheet then I am getting the
following error.
*java.lang.ClassCastException: com.google.gdata.data.TextContent cannot be
cast to com.google.gdata.data.OutOfLineContent*
* at
com.google.gdata.data.spreadsheet.SpreadsheetEntry.getWorksheetFeedUrlString(SpreadsheetEntry.java:115)
*
* at
com.google.gdata.data.spreadsheet.SpreadsheetEntry.getDefaultWorksheet(SpreadsheetEntry.java:142)
*
Please help
*See the code I have used below*
public DocsService service;
public GoogleService spreadsheetsService;
service = new DocsService("myApp");
spreadsheetsService = new GoogleService("wise", "myApp");
service.setUserCredentials(user, pass);
spreadsheetsService.setUserCredentials(user, pass);
URL metafeedUrl =
"https://spreadsheets.google.com/feeds/spreadsheets/private/full";
SpreadsheetQuery query = new SpreadsheetQuery(metafeedUrl);
SpreadsheetQuery query = new SpreadsheetQuery(metafeedUrl);
query.setTitleQuery("myTitle");
query.setTitleExact(true);
query.setMaxResults(10);
SpreadsheetFeed feed = spreadsheetsService.getFeed(query,
SpreadsheetFeed.class);
List<SpreadsheetEntry> spreadsheets = feed.getEntries();
SpreadsheetEntry masterSheet = spreadsheets.get(0);
System.out.println("Can I Edit : " + masterSheet.getCanEdit());
System.out.println("[" + masterSheet.getTitle().getPlainText() + "]");
--------------------------------- Up to the above point it is working
correctly ---------------------
But error is thrown on the below line
*List<WorksheetEntry> worksheets = masterSheet.getWorksheets();*
*Environment*
Windows XP SP3
Java 1.6
Ant 1.8.1
Google Data API (Java) v1.43.0
