Edit

Excel.LinkedEntityCellValue interface

Represents a value whose properties derive from a service.

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.

id

Represents the service source that provided the information in this value.

layouts

Represents layout information for views of this linked entity.

properties

Represents the properties of this linked entity and their metadata.

provider

Represents information that describes the service that provided data in this LinkedEntityCellValue. This information can be used for branding in entity cards.

text

Represents the text shown when a cell with this value is rendered.

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?: "#VALUE!" | string;

Property Value

"#VALUE!" | string

Remarks

API set: ExcelApi 1.16

id

Represents the service source that provided the information in this value.

id: LinkedEntityId;

Property Value

Remarks

API set: ExcelApi 1.16

layouts

Represents layout information for views of this linked entity.

layouts?: EntityViewLayouts;

Property Value

Remarks

API set: ExcelApi 1.16

properties

Represents the properties of this linked entity and their metadata.

properties?: {
            [key: string]: EntityPropertyType;
        };

Property Value

{ [key: string]: Excel.EntityPropertyType; }

Remarks

API set: ExcelApi 1.16

provider

Represents information that describes the service that provided data in this LinkedEntityCellValue. This information can be used for branding in entity cards.

provider?: CellValueProviderAttributes;

Property Value

Remarks

API set: ExcelApi 1.16

text

Represents the text shown when a cell with this value is rendered.

text?: string;

Property Value

string

Remarks

API set: ExcelApi 1.16

type

Represents the type of this cell value.

type: CellValueType.linkedEntity | "LinkedEntity";

Property Value

linkedEntity | "LinkedEntity"

Remarks

API set: ExcelApi 1.16