Excel.CellValueType enum

Package:

excel

Represents the types of the CellValue object.

Remarks

[ API set: ExcelApi 1.16 ]

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

array = "Array"	Represents an ArrayCellValue. [ API set: ExcelApi 1.16 ]
boolean = "Boolean"	Represents a BooleanCellValue. [ API set: ExcelApi 1.16 ]
double = "Double"	Represents a DoubleCellValue. [ API set: ExcelApi 1.16 ]
empty = "Empty"	Represents an EmptyCellValue. [ API set: ExcelApi 1.16 ]
entity = "Entity"	Represents an EntityCellValue. [ API set: ExcelApi 1.16 ]
error = "Error"	Represents an ErrorCellValue. [ API set: ExcelApi 1.16 ]
externalCodeServiceObject = "ExternalCodeServiceObject"	Represents an ExternalCodeServiceObjectCellValue. [ API set: ExcelApi BETA (PREVIEW ONLY) ]
formattedNumber = "FormattedNumber"	Represents a FormattedNumberCellValue. [ API set: ExcelApi 1.16 ]
linkedEntity = "LinkedEntity"	Represents a LinkedEntityCellValue. [ API set: ExcelApi 1.16 ]
localImage = "LocalImage"	Represents a LocalImageCellValue. [ API set: ExcelApi BETA (PREVIEW ONLY) ]
notAvailable = "NotAvailable"	Represents a ValueTypeNotAvailableCellValue. [ API set: ExcelApi 1.16 ]
reference = "Reference"	Represents a ReferenceCellValue. [ API set: ExcelApi 1.16 ]
string = "String"	Represents a StringCellValue. [ API set: ExcelApi 1.16 ]
webImage = "WebImage"	Represents a WebImageCellValue. [ API set: ExcelApi 1.16 ]