官方Google电子表格/驱动器使用情况 [英] Official Google Spreadsheet/Drive usage

问题描述

Google SpreadsheetService似乎是一项工作正在进行中，有时候会突然变得很慢，随机错误消息等等。有些人已经建议我在使用Spreadsheet API时尽可能使用Google Drive API。但我找不到有关Google Drive / Spreadsheet API组合的体面文档。

通过一些调试和试用/错误，我创建了一个'入口点' code> SpreadsheetEntry ：

 字符串lSpreadsheetFileId = pSpreadsheetFile.getId（）; 
 String lSpreadsheetUrlString = String.format（https://spreadsheets.google.com/feeds/spreadsheets/%s，lSpreadsheetFileId）; 
 URL lSpreadsheetUrl =新的URL（lSpreadsheetUrlString）; 
 SpreadsheetEntry lSpreadsheetEntry = mSpreadsheetService.getEntry（lSpreadsheetUrl，SpreadsheetEntry.class）; 
  

现在我可以开始在SpreadsheetService或Google Drive File上进行查询。两者均提供 SpreadsheetEntry 。从这一点来看，这两种情况下的代码都是相同的。

这很有效，但是我自己的Google黑客解决方案可能会破坏界面上的更新。我看到一些贴有更多'正式'方法的帖子：

  urlFactory.getWorksheetFeedUrl（file.getId（），private，充分）; //（或任何其他供稿网址构建器）。 file.getId（）
  

谷歌云端硬盘文件与谷歌的官方'按设计'方式是什么Spreadsheet？

我可以得到一些真正的代码示例（多于;只使用feed等等）？

解决方案

Google电子表格服务已被弃用。使用 Google Apps脚本API 代替您的集成Google云端硬盘和电子表格的实施。使用Apps Script API，您几乎可以在应用程序中实现大部分Google Apps集成。

The Google SpreadsheetService seems a 'work in progress' with sometimes/suddenly slow answers, random error messages etc. As some people already suggest i'm using the Google Drive API where possible when working with the Spreadsheet API. But i couldn't find decent documentation about the Google Drive/Spreadsheet API mix.

With some debugging and trial/error i created an 'entrypoint' at the level of SpreadsheetEntry:

String lSpreadsheetFileId = pSpreadsheetFile.getId(); 
String lSpreadsheetUrlString = String.format("https://spreadsheets.google.com/feeds/spreadsheets/%s", lSpreadsheetFileId); 
URL lSpreadsheetUrl = new URL(lSpreadsheetUrlString); 
SpreadsheetEntry lSpreadsheetEntry = mSpreadsheetService.getEntry(lSpreadsheetUrl, SpreadsheetEntry.class);

Now i can start with a query on the SpreadsheetService or with a Google Drive File. Both deliver a SpreadsheetEntry. From this point the code is equal for both situations.

This works, but is is my own Google hacking solution which could break with an update on the interface. I saw some posts with more 'official' methods:

urlFactory.getWorksheetFeedUrl(file.getId(), "private", "full"); // (or any other feed url builder). file.getId()

What is the official 'by design' way to use Google Drive files with Google Spreadsheet?

Can i get some real code examples (more than; "just use the feed" etc.)?

解决方案

Google Spreadsheet Service is already deprecated. Use Google Apps Script API instead on your implementation on integrating Google Drive and Spreadsheet. Using the Apps Script API, you can almost implement most of the Google Apps integration in your application.

这篇关于官方Google电子表格/驱动器使用情况的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！