TRY NEW VERSION

ISNONTEXT

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

Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE.

Parameters:

Name Type Description
arg1 any

Is the value you want tested: a cell; a formula; or a name referring to a cell, formula, or value.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ISNONTEXT("#N/A"));
oWorksheet.GetRange("A2").SetValue(oFunction.ISNONTEXT(255));
oWorksheet.GetRange("A3").SetValue(oFunction.ISNONTEXT("Online Office"));
builder.SaveFile("xlsx", "ISNONTEXT.xlsx");
builder.CloseFile();

Resulting document