Google-php-spreadsheet-API返回的不是工作表中的所有数据


google-php-spreadsheet-api was return not all data from sheet

如果工作表中有所有空单元格的行。例:

   cell1     cell2
row1 : not empty not empty
row2 : not empty not empty
row3 : empty     empty
row4 : not empty not empty
row5 : not empty not empty

谷歌返回的数据如下:

   cell1     cell2
row1 : not empty not empty
row2 : not empty not empty

如何获取带有空单元格的所有数据。我使用php-google-spreadsheet-client。我的代码:

....
$tokenArray = $client->fetchAccessTokenWithAssertion();
$accessToken = $tokenArray["access_token"];
$serviceRequest = new DefaultServiceRequest($accessToken);
ServiceRequestFactory::setInstance($serviceRequest);
$spreadsheetService = new Google'Spreadsheet'SpreadsheetService();
$tokenArray = $client->fetchAccessTokenWithAssertion();
$accessToken = $tokenArray["access_token"];
$serviceRequest = new DefaultServiceRequest($accessToken);
ServiceRequestFactory::setInstance($serviceRequest);
$spreadsheetService = new Google'Spreadsheet'SpreadsheetService();
$spreadsheetFeed = $spreadsheetService->getSpreadsheets();
$spreadsheet = $spreadsheetFeed->getByTitle('MySpreadsheet');
$worksheetFeed = $spreadsheet->getWorksheets();
$worksheet = $worksheetFeed->getByTitle('Sheet 1');
$listFeed = $worksheet->getListFeed();
foreach ($listFeed->getEntries() as $entry) {
    $values = $entry->getValues();
    $array [] = $values;
}

有一个名为"return-empty"的属性,默认情况下设置为 false,因此只返回提要中不为空的单元格。在单元格查询中将其设置为"true",您将能够更新空单元格的值。

您可以使用官方 Google 文档作为参考。文档包括示例代码。