Excel.NotAvailableErrorCellValue interface

Package:

excel

Represents the value of a cell containing a #N/A! 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.

TypeScript

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.

TypeScript

basicValue?: "#N/A!" | string;

Property Value

"#N/A!" | string

Remarks

[ API set: ExcelApi 1.16 ]

errorType

Represents the type of ErrorCellValue.

TypeScript

errorType?: ErrorCellValueType.notAvailable | "NotAvailable";

Property Value

notAvailable | "NotAvailable"

Remarks

[ API set: ExcelApi 1.16 ]

type

Represents the type of this cell value.

TypeScript

type: CellValueType.error | "Error";

Property Value

error | "Error"

Remarks

[ API set: ExcelApi 1.16 ]