我'm just starting out with the Sheets API, and I' m按照此设置创建新工作表:https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create
在此代码中,spreadsheetBody对象为空 . 为此,我使用了此页面上的示例:https://developers.google.com/sheets/api/samples/writing并将此代码添加到spreadsheetBody变量:
{
"range": "Sheet1!A1:D5",
"majorDimension": "ROWS",
"values": [
["Item", "Cost", "Stocked", "Ship Date"],
["Wheel", "$20.50", "4", "3/1/2016"],
["Door", "$15", "2", "3/15/2016"],
["Engine", "$100", "1", "30/20/2016"],
["Totals", "=SUM(B2:B4)", "=SUM(C2:C4)", "=MAX(D2:D4)"]
],
}
但是,当我发布这个时,我收到错误“收到无效的JSON有效负载 . 未知名称”范围“在'电子表格':找不到字段 . ” . 这可能有什么问题?
1 回答
您正在使用的请求正文是spreadsheets.values.update .
作为示例,创建电子表格的请求主体如下所示 . 在此示例请求正文中,
["Item", "Cost", "Stocked", "Ship Date"], ["Wheel", "$20.50", "4", "3/1/2016"]
用于您使用的the document .样品申请机构:
注意:
sampleSpreadsheet
的电子表格 . 工作表的["Item", "Cost", "Stocked", "Ship Date"], ["Wheel", "$20.50", "4", "3/1/2016"]
值为"A1:D2" .参考文献:
如果这对你的情况没用,我很抱歉 .