Variable InteropScalarTypeConst

Type Declaration

• ReadonlyBoolean: "boolean"

  A boolean value (true or false).

• ReadonlyDate: "date"

  A date value.

  Remarks

  Dates are represented as serial numbers in the underlying data model but can be identified as dates through formatting. This type is used to indicate that a cell's value should be treated as a date, even though it's stored as a number.

• ReadonlyError: "error"

  A cell that contains an error value.

  Remarks

  Error cells represent cells where an error occurred during formula evaluation or data processing.

• ReadonlyNull: "null"

  Represents the absence of a value.

• ReadonlyNumber: "number"

  A numeric value.

  Remarks

  Dates are expressed as formatted numbers within cells. They are internally stored as serial numbers and can be formatted to display as dates.

• ReadonlyRichData: "richData"

  A complex data type represented as IRichData.

  Remarks

  Rich data are objects that have complex structures and can contain data that goes beyond simple strings, numbers, booleans, or error values. For example, hyperlinks and images are represented as rich data.

• ReadonlyString: "string"

  A string value.