Google Script - Applying part of a 2d array to sheet

Question

I've got a sheet which I've used arrays to retrieve data and do some validations/calculations etc.

At the end of my code, I want to apply the updated values back to the sheet.

I've written this line.

shTest.getRange(1,1,sourceArray.length,sourceArray[0].length).setValues(sourceArray);

which works perfectly fine in applying the values of the full 2d array (which has 5 columns) to the sheet.

However I want to apply just the 5th column to column E in my sheet shTest (I declared shTest as a variable for my test sheet earlier in the code)

I got as far as this:

shTest.getRange(1,5,sourceArray.length,1).setValues(sourceArray);

But I couldn't workout how to amend the sourceArray part of my code (after .setValues) to specify that I want the data from the 5 column of the array.

Tanaike · Accepted Answer · 2021-11-02 00:50:42Z

3

In your situation, how about the following modification?

From:

shTest.getRange(1,5,sourceArray.length,1).setValues(sourceArray);

To:

shTest.getRange(1,5,sourceArray.length,1).setValues(sourceArray.map(r => [r[4]]));

By this modification, the values of column "E" (the 5 column in your question) are put to the column "E" of "shTest" sheet.

Reference:

map()

answered Nov 2, 2021 at 0:50

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tanaike Over a year ago

@Michael Liew Thank you for replying. I'm glad your issue was resolved.

Collectives™ on Stack Overflow

Google Script - Applying part of a 2d array to sheet

1 Answer 1

From:

To:

Reference:

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

From:

To:

Reference:

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related