Excel.ErrorCellValue type

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

注解

[ API 集：ExcelApi 1.16 ]

通过以下链接详细了解此类型别名中的类型。

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.RefErrorCellValue、 Excel.SpillErrorCellValue、 Excel.ValueErrorCellValue

示例

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