如何在使用Google电子表格/ Google Apps脚本迭代时跳过隐藏的行 [英] How to skip hidden rows while iterating through Google Spreadsheet w/ Google Apps Script

问题描述

我有一个带有许多隐藏行的Google Spreadsheet，我想在电子表格中的行列表中迭代时跳过它们。

这主要是一个效率问题，因为我正在处理一半以上的行被隐藏，无需检查。

任何帮助将不胜感激。

解决方案

在Apps脚本中没有直接的方法来做到这一点，但有功能请求开放给提供一种方式来获得一行的显示/隐藏状态，如果你想对它进行明星。

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.

解决方案

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.

这篇关于如何在使用Google电子表格/ Google Apps脚本迭代时跳过隐藏的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！