CODEWITHSUNDEEP
javascriptgoogle-apps-script
Max
Max

Reputation: 64

Insert all value of Array in new row - App Script

I'm new in Google App script and I'm trying to insert all value of array in new row and this is my code,

  var lttr = ["a", "b", "c"];
  for (var i=0; i < lttr.length; i++) {
  sheet.getRange(range+1, 1).setValue(lttr);
  }

It only insert the value 

"a"

Not this one

a
b
c

Upvotes: 1

Views: 1920

Answers (2)

Kishan
Kishan

Reputation: 1810

Try the following code:

function insertValues() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  var lttr = [ [ "a" , "b" , "c" ] ];
  var rowNumber = 1;
  var ColumnNumber = 1;
  sheet.getRange(rowNumber,ColumnNumber,lttr.length,lttr[0].length).setValues(lttr);
};

Edit:
If you want to insert the values in a column (that is in rows) then try the following code:

function insertValues() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  var lttr = [ [ "a" ] , [ "b" ] , [ "c" ] ];
  var rowNumber = 1;
  var ColumnNumber = 1;
  sheet.getRange(rowNumber,ColumnNumber,lttr.length,lttr[0].length).setValues(lttr);
};

Upvotes: 1

Cameron Roberts
Cameron Roberts

Reputation: 7367

Instead of looping over your array, simply select the entire range and use the setValues() function rather than setValue().

See: https://developers.google.com/apps-script/reference/spreadsheet/range#setValues(Object)

Upvotes: 0

Related Questions