Excel.CellValue type

Pacote:
excel

Representa o valor numa célula.

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

Comentários

Conjunto de API: ExcelApi 1.16

Usada por

Saiba mais sobre os tipos neste alias de tipo através das seguintes ligações.

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

Exemplos

// 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();
});