Excel.CellValue type

Paket:

excel

Stellt den Wert in einer Zelle dar.

export type CellValue = (ArrayCellValue | BooleanCellValue | DoubleCellValue | EntityCellValue | EmptyCellValue | ErrorCellValue | ExternalCodeServiceObjectCellValue | FormattedNumberCellValue | FunctionCellValue | LinkedEntityCellValue | LocalImageCellValue | ReferenceCellValue | StringCellValue | ValueTypeNotAvailableCellValue | WebImageCellValue) & CellValueExtraProperties;

Hinweise

[ API-Satz: ExcelApi 1.16 ]

Weitere Informationen zu den Typen in diesem Typalias finden Sie unter den folgenden Links.

Excel.ArrayCellValue, Excel.BooleanCellValue, Excel.DoubleCellValue, Excel.EntityCellValue, Excel.EmptyCellValue, Excel.ErrorCellValue, Excel.ExternalCodeServiceObjectCellValue, Excel.FormattedNumberCellValue, Excel.FunctionCellValue, Excel.LinkedEntityCellValue, Excel.LocalImageCellValue, Excel.ReferenceCellValue, Excel.StringCellValue, Excel.ValueTypeNotAvailableCellValue, Excel.WebImageCellValue, Excel.CellValueExtraProperties

Beispiele

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

// This function inserts a web image into the currently selected cell.
await Excel.run(async (context) => {
  // Retrieve image data from the task pane and then clear the input fields.
  const imageUrl = (document.getElementById("url") as HTMLInputElement).value;
  const imageAltText = (document.getElementById("alt-text") as HTMLInputElement).value;
  clearForm();

  // Load the active cell.
  const activeCell = context.workbook.getActiveCell();
  activeCell.load();
  await context.sync();

  if (!imageUrl) {
    console.log("Please enter an image URL.");
    return;
  }

  // Create a web image object and assign the image details.
  const webImage: Excel.WebImageCellValue = {
    type: "WebImage", /* The string equivalent of `Excel.CellValueType.webImage`. */
    address: imageUrl,
    altText: imageAltText     
  };

  // Insert web image into the active cell.
  activeCell.valuesAsJson = [[webImage]];

  await context.sync();
});