javascript - AppendRow error -
i have code in gscript , returns me error:
cannot find method appendrow(string)
the code:
function myfunction() { var ss = spreadsheetapp.getactivespreadsheet(); var sheet = ss.getactivesheet(); var range = sheet.getrange("f1"); var string = range.getvalue(); var targetsheet = ss.getsheetbyname("aux"); targetsheet.appendrow(string); }
any ideas why?
range.getvalue()
returns range, appendrow()
needs array of values https://developers.google.com/apps-script/reference/spreadsheet/sheet#appendrow(object)
Comments
Post a Comment