ExcelScript.FilterOperator enum

Package:

ExcelScript

Remarks

Examples

/**
 * The script filters rows from a table based on a numerical range.
 */
function main(workbook: ExcelScript.Workbook) {
  // Get the first table in the current worksheet.
  const currentSheet = workbook.getActiveWorksheet();
  const table = currentSheet.getTables()[0];

  // Filter to only show rows with a value in the "Exam Score" column that is
  // greater than 0 and less than or equal to 60.
  table.getColumnByName("Exam Score").getFilter().applyCustomFilter(">0", "<=60", ExcelScript.FilterOperator.and);
}

Fields

and
or