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
possible duplicate of google spreadsheet script - Enable filter with a range by script — Jacob Jan Tuinstra
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

Ashton Fei Ashton Fei · Accepted Answer · 2017-09-14T02:55:35

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 Answers