TRY NEW VERSION

SHEET

SHEET(arg1) → { number | string | boolean }

Returns the sheet number of the referenced sheet.

Parameters:

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.

Returns:

Type
number | string | boolean

Example

Copy code
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();

Resulting document