
Announcements
function main(workbook: ExcelScript.Workbook) {
// Get the active worksheet
const sheet = workbook.getActiveWorksheet();
// Get all tables in the worksheet
const tables = sheet.getTables();
// Clear filters for all tables in the worksheet
tables.forEach((table) => {
const filter = table.getAutoFilter();
if (filter) {
filter.clearCriteria();
}
});
// Clear filters applied directly to the worksheet
const autofilter = sheet.getAutoFilter();
if (autofilter) {
autofilter.clearCriteria();
}
console.log("All filters cleared.");
}