使用 Sheets API v4 (Java) 获取 Google Sheets 上次编辑日期 [英] Get Google Sheets Last Edit date using Sheets API v4 (Java)

问题描述

我在 Android 中使用 Google Sheets API v4.

我想做这样的事情:

 电子表格电子表格 = sheetService.spreadsheets().get(spreadsheetId).setIncludeGridData(true).execute();日期日期=电子表格.getProperties().getLastEditDate();

但是，当然，不存在这样的 getLastEditDate() 属性方法.是否有参数或其他 API 方法可以调用以获取此数据?

获得每个单元格的修改日期更好......但我会选择整个电子表格或工作表的日期.

解决方案

这在 Sheets API 中不可用，但您可以使用 Drive API 的 files.get 方法，它在响应中包含一个修改时间".(请注意，默认情况下它不会包含修改时间，您必须在 'fields' 参数中明确要求.)

I'm using the Google Sheets API v4 in Android.

https://developers.google.com/sheets/api/quickstart/android

I need to know when the last modification to the sheet was made (including by user); I need this guy:

I'd like to do something like this:

    Spreadsheet spreadsheet = sheetsService.spreadsheets().get(spreadsheetId).setIncludeGridData(true).execute();
    Date date = spreadsheet.getProperties().getLastEditDate();

But, of course, no such getLastEditDate() property method exists. Is there a parameter or another API method to call to get this data?

Even better would be to get the modified date for each cell... but I'd settle for the date of the entire spreadsheet or sheet.

解决方案

This is not available in the Sheets API, but you may be able to use the Drive API's files.get method, which includes a 'modifiedTime' in the response. (Note that by default it will not include the modified time, you have to explicitly ask for it in the 'fields' parameter.)

这篇关于使用 Sheets API v4 (Java) 获取 Google Sheets 上次编辑日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！