谷歌电子表格API与PHP-如何插入一行的数据开始

Question

我有这样的代码，它在谷歌工作表的顶部附近插入一个空行。

但是如何在这一行中插入数据？

$service = new Google_Service_Sheets($client);     
$dr = new Google_Service_Sheets_DimensionRange();
$dr->setSheetId(0);//first sheet/tab of spreadsheet file
$dr->setDimension('ROWS');
$dr->setStartIndex(1);
$dr->setEndIndex(2);
$ins = new Google_Service_Sheets_InsertDimensionRequest();
$ins->setRange($dr);
$ins->setInheritFromBefore(false);
$ssr = new Google_Service_Sheets_Request();
$ssr->setInsertDimension($ins);
$busr = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest();
$busr->setRequests([$ssr]);
$response = $service->spreadsheets->batchUpdate($spreadsheetId, $busr, []);

Answer 1

使用以下代码解决了问题：

$request = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest([
'requests' => [
'insertDimension' => [
'range' => [
'startIndex' => 1,
'endIndex' => count($array)+1,
'dimension' => 'ROWS',
'sheetId' => 0
]
]
]
]);
$result = $service->spreadsheets->batchUpdate($spreadsheetId, $request);