- API -
cellSearchResult = reaper.AZ_Excel_SearchCellsInWorksheet(excelDocument, searchStr, range, isRegex)
- API Detail-
▼Input values
excelDocument(ExcelDocument): Excel document
searchStr(string): search string
range(string): search range
・row, column single specification
・row1:row2,col1:col2 range specification (optional, default: entire range)
row1:row2,col1:col2 range specification (optional, default: entire range)"
isRegex(boolean): regex search (optional, default: FALSE)
▼Output values
"cellSearchResult(ExcelSheetInfoArray): worksheet array
-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")
sheetList = reaper.AZ_Excel_SearchCellsInAllWorksheets(doc, "01")
Msg("result : " .. tostring(reaper.AZ_GetErrorCode()))
ShowObject(sheetList)
reaper.AZ_Excel_CloseFile(doc)
Excel
AZ_Excel_SearchCellsInAllWorksheets
Supported versions:
1.1.0
onwards
Row search in all sheets
