Inserting rows one by one from a 600 record data-set is taking almost an hour, using the 开发者_JS百科following method:
foreach($people as $person){
$insert['name'] = $associate -> name;
$insertedListEntry = $spreadsheetService->insertRow($insert, $spreadsheetKey, $worksheetId);
}
Is it possible to insert multiple rows at once?
No. See the official Google response on this.
They do suggest parallelizing your requests to speed up the insertion process.
精彩评论