remove filtration for Google spreadsheet using script

Question

I want to remove the filtration from the spreadsheet using a script and after i remove filtered rows the sheet display all row in sheet

I want to do that when I open the spreardsheet.

function ShowColumns() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var maxRows = sheet.getMaxRows();
  var maxCol  = sheet.getMaxColumns();
  sheet.showRows(1, maxRows);
  sheet.showColumns(1,maxCol)
}

I searched for it intensively, but did't find anything.

The code you used was referencing rows and columns.....Therefore my solution. — Jacob Jan Tuinstra, Sep 22 '14 at 14:41
possible duplicate of [google spreadsheet script - Enable filter with a range by script](http://stackoverflow.com/questions/18457235/google-spreadsheet-script-enable-filter-with-a-range-by-script) — Jacob Jan Tuinstra, Sep 26 '14 at 09:17
Hi Ahmed, I flagged your post as a duplicate. See the issue mentioned in the other post, as an explanation as to why it doesn't work. — Jacob Jan Tuinstra, Sep 30 '14 at 13:21

score 0 · Answer 1 · answered Sep 14 '17 at 02:55

There is a way to do it with Google advanced service - Google Sheets API. And here is my function to turn off the filter in Google Sheet.

function removeFilter(sheet){
  var ss = SpreadsheetApp.getActive();
  var spreadsheetId = ss.getId();
  var sheetId = sheet.getSheetId();
  var resource = {
                    "requests": [
                      {
                        "clearBasicFilter": {
                          "sheetId": sheetId
                        }
                      }
                    ]
                  }
  Sheets.Spreadsheets.batchUpdate(resource, spreadsheetId);
}

remove filtration for Google spreadsheet using script

1 Answers1