谷歌电子表格API v4-寻找价值 [英] google spreadsheet API v4 - Find value
问题描述
如何使用新的api v4搜索Google电子表格.
How can i search a google spreadsheet using new api v4.
我在api文档中发现查找/替换,但找不到单元格,它仅替换单元格.那么,除了获取所有数据并在其中搜索的蛮力方法之外,还有什么方法可以在Google电子表格中找到值?
In the api docs i found find/replace, but it can't find cells, it only replaces cells. So is there any method to find a value in a google spreadsheet other than brute-force method of fetching all data and searching in it?
推荐答案
这有点麻烦,但是我使用具有以下公式的API创建了一个单元格,用于搜索工作表中的指定列:
This is a little bit of a kludge, but I create a cell using the API with this formula to search a specified column in a sheet:
=ADDRESS(MATCH("SEARCHSTRING",A1:A999),2)
这确实意味着我必须进行三个不同的调用(写入,读取和清除),并且只能在单个列或一行上使用,但是我发现它对大型电子表格很有用.
This does mean I have to make three different calls (write, read, and clear) and it only works on a single column or row, but I find it useful for large spreadsheets.
这篇关于谷歌电子表格API v4-寻找价值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!