How to import cell data in map list format from app script?

Question

enter image description here

If there is a cell configured like this, the desired result is

{samsung, [Galaxy S20, Galaxy S21, Galaxy S22, Galaxy S23]}, {apple, [iPhone 13]}, {lg,[g7, g8]}

In this way, I would like to obtain data in Java's HashMap<String, List<String>> format.

What should I do?

@TheMaster If so, does spreadsheet.getActiveRange().getValues() read horizontally in the specified range, do you know how to read horizontally? — user21415561
– user21415561, Commented Oct 4, 2023 at 14:30
Sheets api can read horizontally. But it's easy to transpose: stackoverflow.com/a/16705104 — TheMaster
– TheMaster, Commented Oct 4, 2023 at 14:34
@TheMaster Sorry... Oh, not horizontally, but vertically.. I read Samsung row, and then apple row.. This way — user21415561
– user21415561, Commented Oct 4, 2023 at 14:38
I got what you mean. The previous comment is correct and perfect. Sheets api can read both ways( use Advanced Google services). But the easy way is just to transpose. See previous link. — TheMaster
– TheMaster, Commented Oct 4, 2023 at 14:40

TheMaster · Accepted Answer · 2023-10-04 14:54:34Z

0

Try reduce:

/*<ignore>*/console.config({maximize:true,timeStamps:false,autoScroll:false});/*</ignore>*/ 
//getValues result
const d = [
  ['Samsung', 'Apple'],
  ['Galaxy S20', 'iPhone 13'],
  ['Galaxy S21', 'iPhone14'],
];

//Transpose example if needed 
const transposedArr = d[0].map((_, i) => d.map((r) => r[i]));
console.log(transposedArr);

const m = d.reduce((a, r) => {
  const o = Array.isArray(a) ? a.reduce((o, c) => ((o[c] = []), o), {}) : a;
  r.forEach((e, i) => o[d[0][i]].push(e));
  return o;
});
console.log(m);

<!-- https://meta.stackoverflow.com/a/375985/ -->    <script src="https://gh-canon.github.io/stack-snippet-console/console.min.js"></script>

answered Oct 4, 2023 at 14:54

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

How to import cell data in map list format from app script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related