| how to search data within a spreadsheet | harshad23dayalu | 9/21/11 11:29 PM | hey hi i just want to search data within a spreadsheet. i have used "for" loop but it takes too much time if there is too much data in the spreadsheet.its too slow.can u please suggest me any other alternative method which will speed up the process.i |
| Re: how to search data within a spreadsheet | Johninio | 9/21/11 11:36 PM | Fetch your data in bulk from the spreadsheet. Never call getValue() or getValues() from inside the for loop. For example: function search() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var range = shee |
| Re: how to search data within a spreadsheet | Srik | 9/22/11 7:33 AM | Another approach is probably to use the DocsList.find() method. -Srik |
| Re: how to search data within a spreadsheet | ScampMichael | 9/22/11 9:49 AM | Johninio is correct. More at:http://www.google.com/support/forum/p/apps-script/thread?tid=568e89f0691caf00&hl=en |
| Re: how to search data within a spreadsheet | jalbersh | 4/12/12 6:07 AM | Sorry for the late reply. If you want to search for data within a single spreadsheet or across multiple spreadsheets, and avoid writing a complicated script, you can use a 3rd party application, such as CornCracker (http://www.thecorncracker.com) |