- API -
cellSearchResult = reaper.AZ_GSheet_SearchRowsInWorksheet(connection, sheetId, searchStr, targetColumn, range, isRegex)
- API Detail-
▼Input values
connection(GSheetConnection): spreadsheet connection info
sheetId(integer): target sheet ID
searchStr(string): search string
targetColumn(string): row to search
range(string): search range (optional, default: "")
isRegex(boolean): whether to use regex (optional, default: false)
▼Output values
rowSearchResult(GSheetInfo): row search result within the sheet
-Id: sheet ID
-Index: sheet index
-Name: sheet name
-Cells: cell
-number: cell list number
-RowNumber: row number
-Cells: cell
-CellAddress: cell address
-value: value
-RowNumber: row number
-ColNumber: column number
- SCRIPT -
dofile(reaper.AZ_GetLuaInitPath())
require("reaper_AZSTOKE_GOLD")
spreadSheetId = "**********"
sheetId = "**********"
connection = reaper.AZ_GSheet_Connect_UserAccount(spreadSheetId)
resultRow = reaper.AZ_GSheet_SearchRowsInWorksheet(connection, sheetId, "RIGDOCKS", "B")
Msg(reaper.AZ_GetErrorCode())
ShowObject(resultRow)
reaper.AZ_GSheet_Disconnect(connection)
GoogleSpreadSheet
AZ_GSheet_SearchRowsInWorksheet
Supported versions:
1.5.0
onwards
Search for a row within a worksheet
