Retrieving Hidden Rows and Showing Rows by Filter View on Google Spreadsheet using Google Apps Script

[Tanaike]

This is a sample script for retrieving the hidden rows and showing rows by the filter view on Google Spreadsheet using Google Apps Script. In the current stage, there are no methods for directly retrieving the hidden rows and showing rows by the filter view in Spreadsheet service (SpreadsheetApp). And, "isRowHiddenByFilter" of Class Sheet cannot be used for the filter view. But, fortunately, when Sheets API is used, the filter view can be retrieved and created. In this report, the hidden rows and showing rows by the filter view are retrieved using Sheets API. If this was useful for your situation, I'm glad.

https://gist.github.com/tanaikech/43eee17899a3d0a99817f3a2032ae937

[Alex]

@Tanaike,

It seems the data of a filter view is placed on the client side.

Your decision and observation is very valuable. Thank you.

[Tanaike]

Thank you for replying.

Yes. By this, unfortunately, the values filtered by the filter view cannot be directly retrieved.

So, as a workaround, I retrieved the filtered values by the filter view by converting the filter view to the basic filter.