Excel.NullErrorCellValue interface

Represents the value of a cell containing a #NULL! error.

Remarks

[ API set: ExcelApi 1.16 ]

Properties

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicValue

Represents the value that would be returned by Range.values for a cell with this value. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.

errorType

Represents the type of ErrorCellValue.

type

Represents the type of this cell value.

Property Details

basicType

Represents the value that would be returned by Range.valueTypes for a cell with this value.

basicType?: RangeValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]

basicValue

Represents the value that would be returned by Range.values for a cell with this value. When accessed through a valuesAsJson property, this string value aligns with the en-US locale. When accessed through a valuesAsJsonLocal property, this string value aligns with the user's display locale.

basicValue?: "#NULL!" | string;

Property Value

"#NULL!" | string

Remarks

[ API set: ExcelApi 1.16 ]

errorType

Represents the type of ErrorCellValue.

errorType?: ErrorCellValueType.null | "Null";

Property Value

null | "Null"

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]