Returns the sheet number of the referenced sheet.
Name | Type | Description |
arg1 | string | 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. |
builder.CreateFile("xlsx"); const oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); var result = oFunction.SHEET("Sheet1"); oWorksheet.GetRange("C3").SetValue(result); builder.SaveFile("xlsx", "SHEET.xlsx"); builder.CloseFile();