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

javascript - Confirm a form & display message if form is valid with JQuery -

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

ionic framework - Meteor - Error: Failed to execute 'insertBefore' on 'Node' -