How to skip hidden rows while iterating through Google Spreadsheet w/ Google Apps Script

Viewed 9867

I have a Google Spreadsheet with many hidden rows in it, and I want to skip them when iterating through a list of rows in the spreadsheet.

It's mainly an efficiency issue, as I'm dealing with over half of my rows being hidden and in no need of being checked.

Any help would be appreciated.

5 Answers

New API as of 2018 that's useful for this problem: isRowHiddenByUser. See also isRowFilteredByUser.

Related