CODEWITHSUNDEEP
arraysgoogle-apps-script
Aaron
Aaron

Reputation: 3325

appendRow from an array

If I have an array, [Joe, John, Adam, Sam, Bill, Bob] and I want to try to add this to a new row by doing SpreadsheetApp.getActive().getSheetByName('Sheet4').appendRow([array]); , what happens is that the entire list of names goes into 1 cell. Is there a way to break this up so they file away into the same row, but different columns? I need to continue using appendRow however.

I get this:

Bad

But I really want to have it look like this:

Good

 var my2DArrayFromRng = datasheet.getRange("A:A").getValues();
  var a = my2DArrayFromRng.join().split(',').filter(Boolean);

     var array = [];

    for (d in a) {

    array.push(a[d]);

    }

SpreadsheetApp.getActive().getSheetByName('Sheet4').appendRow([array.toString()]);

Upvotes: 0

Views: 4589

Answers (1)

Hink
Hink

Reputation: 2451

You are converting your array to a string before you post it which is causing your issue.

Do not use the array.toString() method inside append row. Instead just append the array as it is.

SpreadsheetApp.getActive().getSheetByName('Sheet4').appendRow(array);

Upvotes: 1

Related Questions