- API -
cellSearchResult = reaper.AZ_Excel_SearchRowsInWorksheet(excelWorksheet, searchStr, targetCulume, range, isRegex)
- API Detail-
▼Input values
excelWorksheet(ExcelWorksheet): worksheet
searchStr(string): search string
targetCulume(string): target column
range(string): search range
・row, column single specification
・row1:row2,col1:col2 range specification (optional, default: entire range)
isRegex(boolean): regex search (optional, default: FALSE)
▼Output values
cellSearchResult(ExcelSheetInfo): worksheet
-Name: worksheet name
-Worksheet: worksheet
-Cells: cell (map)
- key: row number
- value: column (map)
- key: column number
- value: cell value
- SCRIPT -
dofile(reaper.AZ_GetLuaInitPath())
require("reaper_AZSTOKE_GOLD")
doc = reaper.AZ_Excel_OpenFile("D:\\rigdocks\\01_APIDock\\test.xlsx")
worksheet = reaper.AZ_Excel_OpenWorksheet(doc, "b")
sheetList = reaper.AZ_Excel_SearchRowsInWorksheet(worksheet, "e", "J")
Msg("result : " .. tostring(reaper.AZ_GetErrorCode()))
ShowObject(sheetList)
reaper.AZ_Excel_CloseFile(doc)
Excel
AZ_Excel_SearchRowsInWorksheet
Supported versions:
1.1.0
onwards
Search rows within a sheet
