Menu
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.
295
On your computer, go to docs.google.com/spreadsheets/. Open or create a sheet. Select a cell. Type = followed by the sheet name, an exclamation point, and the cell being copied.
Google Docs, Sheets, and Slides all let you save a named version of a file. This helps reduce the number of files you need–and makes it easier to see earlier versions of a document, too.
Tip: To browse a document's version history, you need permission to edit. Important: This feature is available to only Google Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, and Education Plus customers. On your computer, open a document at docs.google.com. Show editors.
See: How to get only recalculated cells from a google spreadsheet via Google spreadsheet API (gdata)
There is an open issue for this that is now marked "Status: Obsolete".
Ether calc, is a google docs style, open source spreadsheet. It should be possible with Ethercalc.
161
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
