Returns the largest value in a set of values. Does not ignore logical values and text.
| Name | Type | Description |
| args | number | string | boolean | array | ApiRange | Up to 255 values (number, text, logical value) for which the largest value will be returned. The first argument is required, subsequent arguments are optional. |
builder.CreateFile("xlsx");
const oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1:A5").GetValue();
var oFunction = Api.GetWorksheetFunction();
var maxA = oFunction.MAX(23, 45, true, "text", 0.89);
oWorksheet.GetRange("C1").SetValue(maxA);
builder.SaveFile("xlsx", "MAXA.xlsx");
builder.CloseFile();