SHEET
function SHEET(arg1: string = null): number | string | booleanDescription
Returns the sheet number of the referenced sheet.
Parameters
- arg1
stringdefault: null Is the name of a sheet or a reference that you want the sheet number of. If omitted the number of the sheet containing the function is returned.
Returns
number | string | booleanTry It
const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var result = oFunction.SHEET("Sheet1");
oWorksheet.GetRange("C3").SetValue(result);