Excel.LinkedEntityIdCulture interface

包:

excel

表示对象的实体 ID 和区域性 LinkedEntityCellValue 。

注解

API 集：ExcelApi 1.19

Excel web 版不支持此接口。

使用方

• Excel.LinkedEntityLoadServiceRequest： 实体

示例

/**
 * Custom function that acts as the data provider for a LinkedEntityDataDomain.
 * Called on demand by Excel to resolve and refresh LinkedEntityCellValue objects.
 * @customfunction
 * @linkedEntityLoadService
 * @param {any} request Request to resolve and refresh LinkedEntityCellValue objects.
 * @return {any} Resolved or refreshed LinkedEntityCellValue objects that were requested in the passed-in request.
 */
function contosoLoadService(request: any): any {
    const notAvailableError = new CustomFunctions.Error(CustomFunctions.ErrorCode.notAvailable);

    try {
        // Parse the request that was passed-in by Excel.
        const parsedRequest: Excel.LinkedEntityLoadServiceRequest = JSON.parse(request);
        // Initialize result to populate and return to Excel.
        const result: Excel.LinkedEntityLoadServiceResult = { entities: [] };

        // Identify the domainId of the request and call the corresponding function to create
        // linked entity cell values for that linked entity data domain.
        const entities: Excel.LinkedEntityIdCulture[] = parsedRequest.entities;
        for (const { entityId } of entities) {
            let linkedEntityResult = null;
            switch (parsedRequest.domainId) {
                case "products": {
                    linkedEntityResult = makeProductLinkedEntity(entityId);
                    break;
                }
                case "categories": {
                    linkedEntityResult = makeCategoryLinkedEntity(entityId);
                    break;
                }
                default:
                    throw notAvailableError;
            }

            if (!linkedEntityResult) {
                // Throw an error to signify to Excel that the resolution or refresh of the requested linkedEntityId failed.
                throw notAvailableError;
            }

            result.entities.push(linkedEntityResult);
        }

        return result;
    } catch (error) {
        console.error(error);
        throw notAvailableError;
    }
}

属性

culture	表示用于创建 LinkedEntityCellValue 对象的语言区域性。
entityId	表示特定于用于创建 LinkedEntityCellValue 对象的服务的标识符。

属性详细信息

culture

表示用于创建 LinkedEntityCellValue 对象的语言区域性。

culture: string;

属性值

string

注解

API 集：ExcelApi 1.19

Excel web 版不支持此属性。

entityId

表示特定于用于创建 LinkedEntityCellValue 对象的服务的标识符。

entityId: string;

属性值

string

注解

API 集：ExcelApi 1.19

Excel web 版不支持此属性。