有没有办法团行有一定的名称(码)就像一个名单的人生活在不同国家和把所有的TX在一起,并LA本

0

的问题

我想到一群人的国家,他们生活中。 我怎么可以这样做使用谷歌应用程序的剧本吗? 我以为使用forEach循环基它们但是我不太确定其方向,以从那里去。 该图像描述这里

google-apps-script google-sheets
2021-11-24 00:54:14
1

最好的答案

1
function sortByState() {
  const sA = ["AL","AK","AS","AZ","AR","CA","CO","CT","DE","DC","FL","GA","GU","HI","ID","IL","IN","IA","KS","KY","LA","ME","MD","MA","MI","MN","MS","MO","MT","NE","NV","NH","NJ","NM","NY","NC","ND","MP","OH","OK","OR","PA","PR","RI","SC","SD","TN","TX","UT","VT","VA","VI","WA","WV","WI","WY"];
  const ss = SpreadsheetApp.getActive();
  const sh = ss.getActiveSheet();
  const hA = sh.getRange(1, 1, 1, sh.getLastColumn()).getValues()[0];
  let idx = {};
  hA.forEach((h, i) => { idx[h] = i; });
  const rg = sh.getRange(2, 1, sh.getLastRow() - 1, sh.getLastColumn());
  const vs = rg.getValues().sort((a,b) => {
    vA = sA.indexOf(a[idx['State']]);
    vB = sA.indexOf(b[idx['State']]);
    return vA - vB;
  });
  rg.clearContent();
  sh.getRange(2,1,vs.length,vs[0].length).setValues(vs);
}
2021-11-24 02:19:38

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Italiano
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................