Office Scripts - Clear all filters (either slicer or table)

Question

I just installed Office Scripts and am new to writing scripts. I need to clear all filters on my worksheet with a button. I found a script on-line and it won't run, shows no errors but isn't doing anything. I'm wondering if the script is missing something, can anyone help me?

Here's the script:
/**
* This script clears any applied criteria from the worksheet's autoFilter.
*/
function main(workbook: ExcelScript.Workbook) {
const currentSheet = workbook.getActiveWorksheet();

// Clear all the criteria currently applied to the autoFilter.
currentSheet.getAutoFilter().clearCriteria();
}

Answer 1

hi

I had a script below run for active sheet , but how to run it to all sheets same time

function main(workbook: ExcelScript.Workbook) {
	let selectedSheet = workbook.getActiveWorksheet();
	// Clear auto filter on selectedSheet
	selectedSheet.getAutoFilter().clearCriteria();
	// Set visibility of row(s) at range A:XFD on selectedSheet to false
	selectedSheet.getRange("A:XFD").setRowHidden(false);
	// Set visibility of column(s) at range A:XFD on selectedSheet to false
	selectedSheet.getRange("A:XFD").setColumnHidden(false);
}