Excel.ErrorCellValueType enum
Represents the types of the ErrorCellValue
object.
Remarks
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();
});
Fields
blocked = "Blocked" | Represents a |
busy = "Busy" | Represents a |
calc = "Calc" | Represents a |
connect = "Connect" | Represents a |
div0 = "Div0" | Represents a |
external = "External" | Represents an |
field = "Field" | Represents a |
gettingData = "GettingData" | Represents a |
name = "Name" | Represents a |
notAvailable = "NotAvailable" | Represents a |
null = "Null" | Represents a |
num = "Num" | Represents a |
placeholder = "Placeholder" | Represents a |
python = "Python" | Represents a |
ref = "Ref" | Represents a |
spill = "Spill" | Represents a |
timeout = "Timeout" | Represents a |
value = "Value" | Represents a |
Office Add-ins