Google表格API 4:如何使用PHP附加到行尾 [英] Google sheets API 4: How to append to the end of the row with PHP

问题描述

我可以通过使用

I am able to update a row by providing the range using the spreadsheets.values.update method, with the following the code:

$range = "A1:B1";
$valueRange= new Google_Service_Sheets_ValueRange();
$valueRange->setValues(["values" => ["a", "b"]]); 
$conf = ["valueInputOption" => "RAW"];
$service->spreadsheets_values->update($spreadsheetId, $range, $valueRange, $conf);

使用 spreadsheets.values.append 方法，并带有以下代码:

When using the spreadsheets.values.append method, with the following code:

$range = "A1:B";
$valueRange= new Google_Service_Sheets_ValueRange();
$valueRange->setValues(["values" => ["a", "b"]]); 
$conf = ["valueInputOption" => "RAW"];
$ins = ["insertDataOption" => "INSERT_ROWS"];
$service->spreadsheets_values->append($spreadsheetId, $range, $valueRange, $conf, $ins);

我收到以下错误消息:

PHP致命错误:调用未定义的方法 Google_Service_Sheets_Resource_SpreadsheetsValues :: append()

PHP Fatal error: Call to undefined method Google_Service_Sheets_Resource_SpreadsheetsValues::append()

怎么了?

推荐答案

这是PHP客户端库已过期的一种情况.现在发布了更新版本(2.0.3)，您可以运行composer update进行检索.

This was a case of the PHP client library being out of date. An updated version (2.0.3) is released now, and you can run composer update to retrieve it.

这篇关于Google表格API 4:如何使用PHP附加到行尾的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！