Multiple Variable Assignment in Javascript/GAS - Is this the most compact way to do it?

Question

Ok so I have a spreadsheet which we extract a 2d array of values from. But really I want one variable per line of this 2d array. The following code does work... but is this the best way to do it?

function testAssignments(){
  config = ss.getRange("C2:C6").getValues();//2D Array
  result = []
  config.forEach(x => result.push(x[0]))
  var [a,b,c,d,e] = result;
  console.log(a,b,c,d,e);
}

I also tried the line config.forEach(x=> x=x[0]) but that didn't work for some reason.

I'm not sure whether this is the direct answer for is this the best way to do it?. So I answer as a comment. As another direction, how about the following sample scripts? 1. const v = config.reduce((o,[c],i) => (o[String.fromCharCode(97 + i)] = c, o), {}) In this script, the values can be retrieved by v.a, v.b,,,. 2. config.forEach(([c],i) => this[String.fromCharCode(97 + i)] = c) In this case, the values can be retrieved by a, b,,,. But in this case, these variables are declared as the global. — Tanaike
– Tanaike, Commented Dec 3, 2021 at 2:15

TheMaster · Accepted Answer · 2021-12-02 19:36:13Z

2

Use .flat instead of .forEach and .push. If you want a different variable name for each element, there isn't a better way.

const [a,b,c,d,e] = ss.getRange("C2:C6").getValues().flat();//1D Array
//or
const [[a],[b],[c],[d],[e]] = ss.getRange("C2:C6").getValues();

answered Dec 2, 2021 at 19:36

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

1 Comment

J. G. Over a year ago

thanks! so clean looking!

Collectives™ on Stack Overflow

Multiple Variable Assignment in Javascript/GAS - Is this the most compact way to do it?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related