如何搜索Google Spreadsheets？ [英] How do I search Google Spreadsheets?

问题描述

我正在做一些详尽的搜索，需要确定一个新的域（URL）是否已经存在于电子表格中。但是，没有任何电子表格对象具有搜索功能，即在大多数Document对象中找到的findText（）。我觉得我失去了一些重要的东西。
我缺少什么？

findText函数： https://developers.google.com/apps-script/class_table#findText

SearchResult对象： https://developers.google.com/apps-script/class_searchresult

电子表格对象： https://developers.google.com/apps-script/ class_sheet

我最好的猜测是尝试转换文档表中特定的Spreadsheet范围，然后执行搜索。 Mendokusai

解决方案

我最终使用电子表格公式来解决我的问题。具体而言，我使用了 MATCH （）函数，它可以查找数组中的字符串（在这种情况下，是同一文档中另一个表中的列）。

这比在数组中循环显着简单虽然效率较低并且不允许全自动化。实际上，当该列达到2000条时，Google Drive会经常冻结，我不得​​不开始使用Excel。尽管如此，Match（）解决方案更适合我所寻找的。

请欣赏所有其他答案。

I am doing a few exhaustive searches and need to determine if a new domain (URL) is already in a Spreadsheet. However, none of the Spreadsheet objects have search functions, namely findText() found in most Document objects. I feel like I am missing something significant. What am I missing?

findText function: https://developers.google.com/apps-script/class_table#findText

SearchResult object: https://developers.google.com/apps-script/class_searchresult

Spreadsheet object: https://developers.google.com/apps-script/class_sheet

My best guess is to try and convert specific Spreadsheet ranges in Document tables, then perform the search. Mendokusai

解决方案

I ended up using spreadsheet formulas to solve my problem instead. Specifically, I used the MATCH() function, which can look up a string in an array (in this case a column in another sheet in the same document).

This is significantly simpler than looping through an array, though less efficient and does not allow for full automation. In fact, when the column reached 2,000 entries, Google Drive froze so often, I had to start using Excel instead. Nevertheless, the Match() solution was more appropriate for what I was looking for.

Appreciate all the other responses though.

这篇关于如何搜索Google Spreadsheets？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！