- API -
GSheetInfo = reaper.AZ_GSheet_CopyWorksheet(connection, sheetId, newSheetName, isNextSheet)
- API Detail-
▼Input values
connection(GSheetConnection): spreadsheet connection info
sheetId(integer): source sheet ID
newSheetName(string): destination sheet name (optional, default: created as a sequential name like Sheet1)
isNextSheet(boolean): whether to create at the index after the source (optional, default: true)
▼Output values
sheetInfo(GSheetInfo): created sheet Info
-Id: sheet ID
-Index: sheet index
-Name: sheet name
- SCRIPT -
dofile(reaper.AZ_GetLuaInitPath())
require("reaper_AZSTOKE_GOLD")
spreadSheetId = "**********"
sheetId = "**********"
connection = reaper.AZ_GSheet_Connect_UserAccount(spreadSheetId)
newSheet = reaper.AZ_GSheet_CopyWorksheet(connection, sheetId, "CopiedSheet")
Msg(reaper.AZ_GetErrorCode())
ShowObject(newSheet)
reaper.AZ_GSheet_Disconnect(connection)
GoogleSpreadSheet
AZ_GSheet_CopyWorksheet
Supported versions:
1.5.0
onwards
Copy a worksheet
