Google App Script/Spreadsheet - 如何获得过滤条件? [英] Google App Script / Spreadsheet - How to get filter criteria?

问题描述

是否可以获取我的数据集的过滤条件.例如，如果我的一列是部门"并且我过滤了数据以仅显示IT".我们如何获得过滤条件IT".我需要将过滤后的标准输入到我的 GAS 中以进行其他一些操作.

Is it possible to get the filter criteria of my data set. For example, if one of my column is "Department" and I filtered the data to display only "IT". How do we get the filtered criteria, "IT". I need to get that filtered criteria into my GAS to do some other manipulation.

谢谢.

推荐答案

试试这个例子以获得一个简单的过滤器.它将过滤第一列中的信息(将 XXX 更改为有意义的内容):

  function onOpen(){

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var filterMenuEntries = [{name: "filter Column1", functionName: "filter"}];
  ss.addMenu("choose filter", filterMenuEntries);

  }

 function filter(){

 var sheet = SpreadsheetApp.getActiveSheet();
 var rows = sheet.getDataRange();
 var numRows = rows.getNumRows();
 var values = rows.getValues();

 for (var i=1; i <=numRows -1; i++){

   var row =values[i];

   // Column value
   var myValue = row[0];

   // filter value 
   if (myValue == "XXX"){

     sheet.hideRows(i+1);

     }

  }

}

这篇关于Google App Script/Spreadsheet - 如何获得过滤条件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！