Get filtered data (method 2)
Wed Mar 09 2022 13:32:29 GMT+0000 (Coordinated Universal Time)
Saved by
@massa
var filter = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheetName").getFilter();
var criteriaValues = filter.getColumnFilterCriteria(columnPosition).getCriteriaValues();
Logger.log("criteria Values length " + criteriaValues.length);
Logger.log(criteriaValues);
var visibleValues = filter.getColumnFilterCriteria(columnPosition).getVisibleValues();
Logger.log("visible Values length " + visibleValues.length);
Logger.log(visibleValues);
var hiddenValues = filter.getColumnFilterCriteria(columnPosition).getHiddenValues();
Logger.log("hidden Values length " + hiddenValues.length);
Logger.log(hiddenValues);
content_copyCOPY
https://localcoder.org/how-to-copy-filtered-spreadsheet-data-with-apps-script
Comments