Excel.EntityViewLayouts interface

Hinweise

API-Satz: ExcelApi 1.16

Verwendet von

• Excel.EntityCellValue: Layouts
• Excel.LinkedEntityCellValue: Layouts

Beispiele

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/20-data-types/data-types-entity-attribution.yaml

function makeProductEntity(productID: number, productName: string, product?: any) {
  const entity: Excel.EntityCellValue = {
    type: Excel.CellValueType.entity,
    text: productName,
    properties: { /* Excel.EntityPropertyType */
      "Product ID": {
        type: Excel.CellValueType.string,
        basicValue: productID.toString() || ""
      },
      "Product Name": {
        type: Excel.CellValueType.string,
        basicValue: productName || ""
      },
      "Quantity Per Unit": {
        type: Excel.CellValueType.string,
        basicValue: product.quantityPerUnit || ""
      },
      // Add Unit Price as a formatted number.
      "Unit Price": {
        type: Excel.CellValueType.formattedNumber,
        basicValue: product.unitPrice,
        numberFormat: "$* #,##0.00"
      },
      "Units In Stock": {
        type: Excel.CellValueType.double,
        basicValue: product.unitsInStock
      },
      "Units On Order": {
        type: Excel.CellValueType.double,
        basicValue: product.unitsOnOrder
      },
      "Reorder Level": {
        type: Excel.CellValueType.double,
        basicValue: product.reorderLevel
      }
    },
    layouts: { /* Excel.EntityViewLayouts */
      card: { /* Excel.EntityCardLayout */
        title: { property: "Product Name" },
        sections: [ /* Excel.CardLayoutSection */
          {
            layout: "List",
            properties: ["Product ID"]
          },
          {
            layout: "TwoColumn", /* Excel.CardLayoutTwoColumnSection */
            title: "Quantity and price",
            collapsible: true,
            collapsed: false,
            properties: ["Quantity Per Unit", "Unit Price"]
          },
          {
            layout: "Table", /* Excel.CardLayoutTableSection */
            title: "Stock information",
            collapsible: true,
            collapsed: false,
            properties: ["Units In Stock", "Units On Order", "Reorder Level"]
          }
        ]
      }
    },
    provider: {
      description: product.providerName, // Name of the data provider. Displays as a tooltip when hovering over the logo. Also displays as a fallback if the source address for the image is broken.
      logoSourceAddress: product.sourceAddress, // Source URL of the logo.
      logoTargetAddress: product.targetAddress // URL to open when you select the logo.
    }
  };

  return entity;
}

Eigenschaften

card

card?: CardLayout;

compact

compact?: CompactLayout;