google-apps-script - 如何检查列中的值

Question

我有一项任务需要检查电子表格 A 的单元格中的值是否在电子表格 B 的列中。获得列的值后，我有：

    function test() {
a = [['sđt'], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [9.27915789E8], [6.5762895E8], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [], [], [], [], [], [], [], [], [], [], [], []];
b = [9.27915789E8];
Logger.log(b in a)

}

输出：假

我该怎么做才能使它成为 TRUE ？

标签： google-apps-scriptgoogle-sheets

Answer 1

function test() {
  const a = [['sđt'], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [9.27915789E8], [6.5762895E8], [9.27915789E8], [6.5762895E8], [8.8543159E8], [6.48624091E8], [9.43630775E8], [6.45340742E8], [8.90007311E8], [6.1349516E8], [], [], [], [], [], [], [], [], [], [], [], []].filter(e => e[0]).filter((e, i) => i > 0).flat();
  const b = [9.27915789E8];
  Logger.log(a.includes(b[0]));
}

包括

筛选

平坦的