Google Sheets API v4:batchGet无法正常工作

问题描述：

无法使Google Sheets API v4使用batchGet返回多个范围值.它给出了以下错误(尽管文档说它需要valueRanges []，所有范围和电子表格ID都是正确的):额外的args块必须是javascript对象文字.(第2行，文件代码")"

Can't get Google Sheets API v4 to return multiple range values using batchGet. It is giving the following error (although the documentation says it needs valueRanges[], all the ranges and spreadsheetId are correct): "Extra args block must be a javascript object literal. (line 2, file "Code")"

您能帮忙解决一下吗?谢谢你.这是代码:

Could you please help sort it out? Thank you. Here is the code:

function readRange(spreadsheetId) {
  var response = Sheets.Spreadsheets.Values.batchGet("someSpreadSheetID", ["Sheet1!D7:F7", "Sheet1!J7:L7"]);
  Logger.log(response.values);
}

答

此修改后的脚本如何?为了使用此功能，请在API控制台上启用Sheet API v4，并在Advanced Google Services上启用Sheet API v4.

How about this modified script? In order to use this, please enable Sheet API v4 on API console and enable Sheet API v4 at Advanced Google Services.

function readRange(spreadsheetId) {
  var response = Sheets.Spreadsheets.Values.batchGet(
    "someSpreadSheetID",
    {ranges: ["Sheet1!D7:F7", "Sheet1!J7:L7"]}
  );
  Logger.log(response.valueRanges);
}

Google Sheets API v4:batchGet无法正常工作

相关推荐