如何通过Google电子表格API(gdata)仅从Google电子表格中获取重新计算的单元格 [英] How to get only recalculated cells from a google spreadsheet via Google spreadsheet API (gdata)

问题描述

Gdata提供了一种基于时间戳仅从Google电子表格中获取更改的单元格的方法. 如何为Gdata调用创建时间戳?

Gdata offers a way to get only changed cells from a google spreadsheet, based on a time stamp. How should I create the time stamp for the Gdata call?

即只有发布时间等于或晚于指定时间戳的条目才会被返回." setPublishedMax() https://developers.google.com/gdata/javadoc/com/google/gdata/client/Query#setPublishedMax(com.google.gdata.data.DateTime)

i.e. "Only entries with a published time equal to or later than the specified timestamp will be returned." setPublishedMax() https://developers.google.com/gdata/javadoc/com/google/gdata/client/Query#setPublishedMax(com.google.gdata.data.DateTime)

是否可以从服务器获取当前时间?如果我创建本地时间戳，如何在哪个时区同步它?

Is there are a way to pull the current time from the server? If I create a local time stamp, how can I sync it, what time zone?

推荐答案

不可能，它产生:

com.google.gdata.util.ServiceForbiddenException:确定此服务不支持更新的分钟数

com.google.gdata.util.ServiceForbiddenException: OK This service does not support the updated-min

问题在这里: https://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=1388

这篇关于如何通过Google电子表格API(gdata)仅从Google电子表格中获取重新计算的单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！