问题:

With the introduction of the new version of the Google sheets (spreadsheets), the Gdata API no longer work. (see https://support.google.com/drive/answer/3543688) Are there new APIs available for the new Google sheets or will Gdata be updated to support the new Sheets? Or are there any workarounds?

This is currently breaking our production code which programmatically reads contents from Google Sheets using the gdata API. Please help!

回答1:

It appears that Google has finally updated their Gdata APIs to work with the new sheets now. Notice that the page: https://support.google.com/drive/answer/3543688 has removed the line about Gdata not working.

I have also tested this and it seems to be working for us now.

回答2:

Can create old style sheets at http://g.co/oldsheets Painful to do it programatically

回答3:

Google say: "However, there are a handful of features that are still in development and not yet available." the list includes Gdata

.... "There are also a few features that we'll be retiring in the new Google Sheets" ... the list does not include Gdata.

https://support.google.com/drive/answer/3543688

Switching back: If you switch back to old style sheets, it will ask you why and you can leave a comment. https://support.google.com/drive/answer/3544847#workarounds