- API -
worksheetList = reaper.AZ_GSheet_GetWorksheetList(connection, searchStr, isRegex, excludeList)
- API Detail-
▼Input values
connection(GSheetConnection): spreadsheet connection info
searchStr(string): search string (optional, default: "")
isRegex(boolean): whether to use regex (optional, default: false)
excludeList(stringArray): list of strings to exclude (optional, default: {""})
▼Output values
worksheetList(GSheetInfoArray): list of retrieved sheet Info
-number: list index
-Id: sheet ID
-Index: sheet index
-Name: sheet name
- SCRIPT -
dofile(reaper.AZ_GetLuaInitPath())
require("reaper_AZSTOKE_GOLD")
spreadSheetId = "**********"
connection = reaper.AZ_GSheet_Connect_UserAccount(spreadSheetId)
sheetList = reaper.AZ_GSheet_GetWorksheetList(connection, "PL_", false, {"2"})
Msg(reaper.AZ_GetErrorCode())
ShowObject(sheetList)
reaper.AZ_GSheet_Disconnect(connection)
GoogleSpreadSheet
AZ_GSheet_GetWorksheetList
Supported versions:
1.5.0
onwards
Get worksheet list
