如何使用google spreadsheet api (PHP)合并google表格中的两个单元格?
发布于 2019-06-19 00:47:20
对于有人寻找解决方案来做合并使用谷歌电子表格API在PHP中,然后你可以按照如下所示,但请注意,这段代码要运行,你必须使用谷歌工作表API PHP SDK。此外,您必须使用use关键字在顶部的类或php文件中声明代码中使用的这些类。
####### Set the Grid Range in sheet ########
$rangeinst = new Google_Service_Sheets_GridRange();
$rangeinst->setSheetId($setSheetId); //set your sheet id here
$rangeinst->setStartRowIndex(0); //start row
$rangeinst->setEndRowIndex(2); //end row
$rangeinst->setStartColumnIndex(0); //start column
$rangeinst->setEndColumnIndex(4); //end column
########## Set Grid range object in merging #########
$merge = new Google_Service_Sheets_MergeCellsRequest();
$merge->setMergeType('MERGE_COLUMNS'); //Can be MERGE_ROWS or MERGE_ALL for more you can check https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/other#GridRange
$merge->setRange($rangeinst);
//update the sheet with merge request object
$requestMergeBody = new Google_Service_Sheets_Request();
$requestMergeBody->setMergeCells($merge);
$mergerequestBatchBody = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest();
$mergerequestBatchBody->setRequests($requestMergeBody);
$service->spreadsheets->batchUpdate($spreadsheetId, $mergerequestBatchBody); //$spreadsheetId is different than sheet id (a sheet index) so don't confuse with these two terms,
//spreadsheetId will be your whole spreadsheet unique Id that you can found in your share url of spreadsheet and will look something like this 1Mbd5MsTixm5SE0HHl0-yVqj_4ENwijSdNm5OAiG4pN0https://stackoverflow.com/questions/42943674
复制相似问题