Office scripts filter

[rick051112]

Hi, I am new to office scripts and just need help with filtering

Here is my code:

let ws = workbook.getActiveWorksheet()
ws.getAutoFilter().apply(ws.getAutoFilter().getRange(), 0, {filteron: ExcelScript.Filteron.values, values: ['Jello']})

I keep getting the error " autofilter apply: the argument is invalid or missing or has an incorrect format"

I want to filter the first column in the worksheet by the string "jello"

Thanks

 

[ExcelToDAX]

Jello should be in double quotes not single. For example, here is a simple code I wrote in Office Scripts:

function main(workbook: ExcelScript.Workbook) {
    let productTable = workbook.getTable("Table1");
    productTable.getColumnByName("PRODUCT").getFilter().applyValuesFilter(["CAR"]);
}