Returns the k-th largest value in a data set. For example, the fifth largest number.
| Name | Type | Description |
| arg1 | ApiRange | Array.<number> | The array or range of data for which the k-th largest value will be determined. |
| arg2 | number | The position (from the largest) in the array or cell range of data to return. |
builder.CreateFile("xlsx");
const oWorksheet = Api.GetActiveSheet();
let numbersArr = [4, 13, 27, 56, 46, 79, 22, 12];
// Place the numbers in cells
for (let i = 0; i < numbersArr.length; i++) {
oWorksheet.GetRange("A" + (i + 1)).SetValue(numbersArr[i]);
}
let oFunction = Api.GetWorksheetFunction();
let oRange = oWorksheet.GetRange("A1:A8");
let largePostion = 4;
let kLargest = oFunction.LARGE(oRange, largePostion);
oWorksheet.GetRange("C1").SetValue(kLargest);
builder.SaveFile("xlsx", "LARGE.xlsx");
builder.CloseFile();