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

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -