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

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -