我一直在尝试让追加行示例工作几个小时,但没有成功,我没有收到任何错误,但我的电子表格根本没有更新。
https://developers.google.com/sheets/samples/writing#append_values https://developers.google.com/sheets/samples/writing#append_values
function insertInSpreadSheet(sheetId, sheetService) {
var body = {
"range": "Sheet1",
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)"]
]
}
var params = {
spreadsheetId: sheetId,
"range": "Sheet1",
valueInputOption: "USER_ENTERED",
media: {
body: body
}
};
sheetService.spreadsheets.values.append(params, function(err, res) {
if(err){
console.log(err);
return;
}
console.log(res);
return;
});
}//end function
回复:
{
spreadsheetId: '1NvBbTlET7G5yhuuFF6zj-7LQUQ9TI85_geviRLuzCD0',
updates: {
spreadsheetId: '1NvBbTlET7G5yhuuFF6zj-7LQUQ9TI85_geviRLuzCD0',
updatedRange: 'Sheet1!A1'
}
}
我错过了什么吗?
Edit
我的电子表格完全是空的