Compartilhar via

Excel.ErrorCellValue type

  • Referência
Pacote:
excel

Representa um valor de célula que contém um erro.

export type ErrorCellValue = BlockedErrorCellValue | BusyErrorCellValue | CalcErrorCellValue | ConnectErrorCellValue | Div0ErrorCellValue | ExternalErrorCellValue | FieldErrorCellValue | GettingDataErrorCellValue | NotAvailableErrorCellValue | NameErrorCellValue | NullErrorCellValue | NumErrorCellValue | PlaceholderErrorCellValue | PythonErrorCellValue | RefErrorCellValue | SpillErrorCellValue | TimeoutErrorCellValue | ValueErrorCellValue;

Comentários

[ Conjunto de API: ExcelApi 1.16 ]

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

Excel.BlockedErrorCellValue, Excel.BusyErrorCellValue, Excel.CalcErrorCellValue, Excel.ConnectErrorCellValue, Excel.Div0ErrorCellValue, Excel.ExternalErrorCellValue, Excel.FieldErrorCellValue, Excel.GettingDataErrorCellValue, Excel.NotAvailableErrorCellValue, Excel.NameErrorCellValue, Excel.NullErrorCellValue, Excel.NumErrorCellValue, Excel.PlaceholderErrorCellValue, Excel.PythonErrorCellValue, Excel.RefErrorCellValue, Excel.SpillErrorCellValue, Excel.TimeoutErrorCellValue, Excel.ValueErrorCellValue

Exemplos

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

// This function sets the value of cell A1 to a #BUSY! error using data types.
await Excel.run(async (context) => {
  // Retrieve the Sample worksheet and cell A1 on that sheet.
  const sheet = context.workbook.worksheets.getItemOrNullObject("Sample");
  const range = sheet.getRange("A1");

  // Get the error data type and set its type to `busy`.
  const error: Excel.ErrorCellValue = {
    type: Excel.CellValueType.error,
    errorType: Excel.ErrorCellValueType.busy
  };

  // Set cell A1 as the busy error.
  range.valuesAsJson = [[error]];
  await context.sync();
});