Excel.LinkedEntityCellValue interface

注釈

API セット: ExcelApi 1.16

使用元

• Excel.LinkedEntityCellValueLoadedEventArgs: linkedEntityCellValue
• Excel.LinkedEntityLoadServiceResult: エンティティ
• Excel.PlaceholderErrorCellValue: target
• Excel.Workbook: getLinkedEntityCellValue

例

// Creates a linked entity cell value with properties and a card layout.
// This is typically returned from a linked entity load service function.
const productLinkedEntity: Excel.LinkedEntityCellValue = {
    type: "LinkedEntity",
    text: "Chai",
    id: {
        entityId: "P1",
        domainId: "products",
        serviceId: 268436224, // Service ID used by Excel to identify linked entity cell values associated with an add-in.
        culture: "en-US"
    },
    properties: {
        "Product Name": {
            type: "String",
            basicValue: "Chai"
        },
        "Unit Price": {
            type: "FormattedNumber",
            basicValue: 18,
            numberFormat: "$* #,##0.00"
        },
        Discontinued: {
            type: "Boolean",
            basicValue: false
        }
    },
    layouts: {
        compact: {
            icon: "ShoppingBag"
        },
        card: {
            title: { property: "Product Name" },
            sections: [
                {
                    layout: "List",
                    properties: ["Product Name", "Unit Price", "Discontinued"]
                }
            ]
        }
    }
};

プロパティ

basicType

basicType?: RangeValueType.error | "Error";

basicValue

basicValue?: "#VALUE!" | string;

id

id: LinkedEntityId;

layouts

layouts?: EntityViewLayouts;

properties

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

provider

provider?: CellValueProviderAttributes;

text

text?: string;

type

type: CellValueType.linkedEntity | "LinkedEntity";