If I have a WorksheetEntry, how do I get the worksheet ID for use in query URL building?
Specifically, I have a SpreadsheetEntry and I want to get a cell feed for the first worksheet with the projection set to "values" instead of "full". The worksheet id is "od6" but WorksheetEntry.getId() returns a full URL, not the ID (as getId would imply): https://spreadsheets.google.com/feeds/worksheets/*spreadsheetkey*/od6 I have tried the following methods to build a cell feed query string with "values" projection but they do not work: String wsid = sheetentry.getWorksheets().get(0).getId(); URL cellq = FeedURLFactory.getDefault().getCellFeedUrl(this.id, wsid, "private", "values"); // but wsid was a full URL and so the result is malformed And: URL cellq = sheetentry.getWorksheets().get(0).getCellFeedUrl(); // projection cannot be changed And: CellQuery cellq = sheet.createCellQuery(); // but CellQuery does not expose a setProjection() method How do I do this? Thanks, Jason
