How to read data from a specific version of Google Sheet?

Question

I found code examples in internet for reading the data from the latest version of Google Sheet as below:

SpreadsheetService service = new SpreadsheetService("Print Google Spreadsheet Demo");
service.setUserCredentials(GOOGLE_ACCOUNT_USERNAME, GOOGLE_ACCOUNT_PASSWORD);
URL metafeedUrl = new URL(SPREADSHEET_URL);
SpreadsheetEntry spreadsheet = service.getEntry(metafeedUrl, SpreadsheetEntry.class);
URL listFeedUrl = ((WorksheetEntry) spreadsheet.getWorksheets().get(0)).getListFeedUrl();

But I cannot find any examples, to access a particular version of the Google Sheet and get a cells value in that revision.

Also please let me know, if the above requirement can be completed using google spreadsheet APIs.

score 1 · Accepted Answer · edited May 23 '17 at 12:10

1

Not possible:

See: How to get only recalculated cells from a google spreadsheet via Google spreadsheet API (gdata)

Open Issue

There is an open issue for this that is now marked "Status: Obsolete".

Ethercalc

Ether calc, is a google docs style, open source spreadsheet. It should be possible with Ethercalc.

edited May 23 '17 at 12:10

Community

1
1

answered Nov 24 '14 at 00:10

eddyparkinson

3,680
4
26
52

Checking more on this topic. I will get back to you ASAP. – Vel Ganesh Nov 24 '14 at 09:00
Suggest you also check google-apps-script. There is a chance they have added this. – eddyparkinson Nov 24 '14 at 23:34

How to read data from a specific version of Google Sheet?

1 Answers1

Not possible:

Open Issue

Ethercalc

Linked

Related