问Google Sheets |如何使用脚本过滤多个列

EN

function setFilter() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var filterSettings = {};

  var condition_value = {
    "type": "TEXT_EQ",
    "values": [{"userEnteredValue": "D"}]
  };

  filterSettings.range = {
    sheetId: ss.getActiveSheet().getSheetId()
  };

  filterSettings.criteria = {};
  var columnIndex = 8;
  filterSettings['criteria'][columnIndex] = {
    'condition' : condition_value
  };

  var request = {
    "setBasicFilter": {
      "filter": filterSettings
    }
  };
  Sheets.Spreadsheets.batchUpdate({'requests': [request]}, ss.getId());
}