top of page
- API -

value = reaper.AZ_GSheet_GetCellValue(connection, sheetId, cell)

-　API Detail-

▼Input values

connection(GSheetConnection): spreadsheet connection info

sheetId(integer): target sheet ID

cell(string): cell to get the value from (A1 notation)


▼Output values

value(varType): retrieved cell value

- SCRIPT -

dofile(reaper.AZ_GetLuaInitPath())                

require("reaper_AZSTOKE_GOLD")                


spreadSheetId = "**********"


sheetId = "**********"


connection = reaper.AZ_GSheet_Connect_UserAccount(spreadSheetId)


value = reaper.AZ_GSheet_GetCellValue(connection, sheetId, "B3")


Msg(reaper.AZ_GetErrorCode())


Msg(value)


reaper.AZ_GSheet_Disconnect(connection)

GoogleSpreadSheet

AZ_GSheet_GetCellValue

Supported versions:

1.5.0

onwards

Get cell value (by cell address)

bottom of page