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

google-apps google-sheets google-apps-script
kevlar1818 picture kevlar1818 · Jul 22, 2011 · Viewed 7.8k times · Source

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.

Answer

Jan Kleinert picture Jan Kleinert · Aug 25, 2011

There's no direct way of doing this in Apps Script, but there is a feature request open to provide a way get the show/hide status of a row, if you want to star it.

Related questions

Script to summarise data not updating

I have a Google spreadsheet of timesheet data; it has a sheet for each month, each sheet is a lot of six column blocks, one block per client. I have created a summary sheet that goes and gets the total …

Read More
If var isnumber, for script

I need to run a script which contains the logic: If isNumber, Then DoSomething. I've run other such if then tests such as if blank, and if cell contains "x". It should be simple but I can't find a solution. …

Read More
Open Google Docs Spreadsheet by name

I have a situation where a script is taking input data and sending it to a spreadsheet. After a while, this spreadsheet becomes too big. Right now we have to manually move the items from the the primary spreadsheet to …

Read More