I used Google data API to retrieve data in Google spreadsheet .
Screen shot of Google Spreadsheet.
[image: enter image description here]
SpreadsheetService service =
new SpreadsheetService("MySpreadsheetIntegration-v1");
service.setUserCredentials(USERNAME, PASSWORD);
URL SPREADSHEET_FEED_URL = new URL(
"https://spreadsheets.google.com/feeds/list/worksheetID/od6/private/basic";);
// Make a request to the API and get all spreadsheets.
ListFeed feed = service.getFeed(SPREADSHEET_FEED_URL, ListFeed.class);
List<ListEntry> spreadsheets = feed.getEntries();
// Iterate through all of the spreadsheets returned
for ( ListEntry spreadsheet : spreadsheets) {
// Print the title of this spreadsheet to the screen
System.out.println(spreadsheet.getPlainTextContent());
}
Output:
_chk2m: 24, _ciyn3: 27, _ckd7g: 30, _clrrx: 33, _cyevm: 36, _cztg3: 39,
_d180g: 42, _d2mkx: 45, _cssly: 48, _cu76f: 51, _cvlqs: 54, _cx0b9: 57,
_d9ney: 32, _db1zf: 34, _dcgjs: 36, _ddv49: 38, _d415a: 40, _d5fpr: 42,
_d6ua4: 44, _d88ul: 46, _dkvya: 48, _dmair: 50, _dnp34: 52, _dp3nl: 54,
_df9om: 56, _dgo93: 58, _di2tg: 60, _djhdx: 62, _dw4je: 64, _dxj3v: 66,
_dyxo8: 68, _e0c8p: 70, _dqi9q: 72
How do i get date as a String instead of getting "_chk2m" ?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
