Excel.ErrorCellValue type

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

Remarks

API set: ExcelApi 1.16

Learn more about the types in this type alias through the following links.

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

Examples

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