top of page
- API -
worksheetList = reaper.AZ_Excel_GetWorksheetList(excelDocument, excludeList, isRegex)
- API Detail-
▼Input values
excelDocument(ExcelDocument): Excel document
excludeList(StringArray): exclusion list (optional, default: empty)
isRegex(boolean): regex search (optional, default: FALSE)
▼Output values
worksheetList(ExcelSheetInfoArray): worksheet
-Worksheet: worksheet pointer
- Name: worksheet name
- SCRIPT -
dofile(reaper.AZ_GetLuaInitPath())
require("reaper_AZSTOKE_GOLD")
doc = reaper.AZ_Excel_OpenFile("D:\\rigdocks\\01_APIDock\\test.xlsx")
sheetList = reaper.AZ_Excel_GetWorksheetList(doc, "PL_", false, {"2"})
Msg("result : " .. tostring(reaper.AZ_GetErrorCode()))
ShowObject(sheetList)
reaper.AZ_Excel_CloseFile(doc)
Excel
AZ_Excel_GetWorksheetList
Supported versions:
1.1.0
onwards
Get worksheet list
bottom of page