CODEWITHSUNDEEP
javaeclipsegoogle-sheets-api
Saurabh Saxena
Saurabh Saxena

Reputation: 3205

Trying to retrieve list of all spreadsheets in Google Docs

I am new to use Google Spreadsheet APIs.

I want to retrieve the list of all the spreadsheets for the currently authenticated user using JAVA.

What should i do?

Upvotes: 1

Views: 605

Answers (1)

Jayendra
Jayendra

Reputation: 52799

The google data api developer guide documentation explains with examples.

http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListingSpreadsheets

Check the java tab.

URL metafeedUrl = new URL("https://spreadsheets.google.com/feeds/spreadsheets/private/full");
SpreadsheetFeed feed = service.getFeed(metafeedUrl, SpreadsheetFeed.class);
List<SpreadsheetEntry> spreadsheets = feed.getEntries();
for (int i = 0; i < spreadsheets.size(); i++) {
  SpreadsheetEntry entry = spreadsheets.get(i);
  System.out.println("\t" + entry.getTitle().getPlainText());
}

service is an authenticated SpreadsheetService object

SpreadsheetService service = new SpreadsheetService();  
service.setAuthSubToken(sessionAuthToken);

Upvotes: 4

Related Questions