如何更新多个单元格在谷歌工作表通过工作表Api？

Question

我在PHP服务器中使用以下代码更新单元格中的值A4

$values = array(
    array('1234'),
    array('abcd')
);

$range = array(array('Sheet1!A4'),array('Sheet1!A7'));

$data = [];
$data[] = new Google_Service_Sheets_ValueRange([
    'range' => $range,
    'values' => $values
]);
// Additional ranges to update ...
$body = new Google_Service_Sheets_BatchUpdateValuesRequest([
    'valueInputOption' => $valueInputOption,
    'data' => $data
]);
$result = $service->spreadsheets_values->batchUpdate($spreadsheetId, $body);

运行此请求时，收到以下错误：

"error": {
    "code": 400,
    "message": "Invalid JSON payload received. Unknown name \"range\" at 'data[0]': Proto field is not repeating, cannot start list.",
    "errors": [
      {
        "message": "Invalid JSON payload received. Unknown name \"range\" at 'data[0]': Proto field is not repeating, cannot start list.",
        "reason": "invalid"
      }
    ],
    "status": "INVALID_ARGUMENT"
  }
}

在PHP中，一次更新多个不连续单元格的GoogleSheetsAPI请求的正确方法是什么？

Answer 1

通过以以下格式发布数据解决了此问题：

$data = [
    [
        'range'=> 'Sheet1!A4',
        'values'=> array(
        array('1234')
        )
    ],[
        'range'=> 'Sheet1!A7',
        'values'=> array(
        array('abcd')
        )
    ]
];
// Additional ranges to update ...
$body = new Google_Service_Sheets_BatchUpdateValuesRequest([
    'valueInputOption' => 'USER_ENTERED',
    'data' => $data
]);
$result = $service->spreadsheets_values->batchUpdate($spreadsheetId, $body);