Excel.LinkedEntityCellValue interface

Represents a value whose properties derive from a service.

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.

cardLayout

Represents the layout of this linked entity in card view. If the CardLayout object doesn't have a layout property, it default value is "Entity".

id

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

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 ]

cardLayout

Represents the layout of this linked entity in card view. If the CardLayout object doesn't have a layout property, it default value is "Entity".

cardLayout?: CardLayout;

Property Value

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 ]

properties

Represents the properties of this linked entity and their metadata.

properties?: {
            [key: string]: CellValue & {
                propertyMetadata?: CellValuePropertyMetadata;
            };
        };

Property Value

{ [key: string]: Excel.CellValue & { propertyMetadata?: Excel.CellValuePropertyMetadata; }; }

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 ]