Excel.ChangedEventDetail interface

Package:

excel

Provides information about the details of a WorksheetChangedEvent or TableChangedEvent.

Remarks

[Api set: ExcelApi 1.9]

Properties

valueAfter	Represents the value after the change. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string.
valueAsJsonAfter	Represents the type of value after the change. Unlike valueAfter, valueAsJsonAfter can represent all cell values, such as formatted number, web image, and entity data types.
valueAsJsonBefore	Represents the type of value before the change. Unlike valueBefore, valueAsJsonBefore can represent all cell values, such as formatted number, web image, and entity data types.
valueBefore	Represents the value before the change. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string.
valueTypeAfter	Represents the type of value after the change.
valueTypeBefore	Represents the type of value before the change.

Property Details

valueAfter

Represents the value after the change. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string.

valueAfter: any;

Property Value

any

Remarks

[Api set: ExcelApi 1.9]

valueAsJsonAfter

Represents the type of value after the change. Unlike valueAfter, valueAsJsonAfter can represent all cell values, such as formatted number, web image, and entity data types.

valueAsJsonAfter: CellValue;

Property Value

Excel.CellValue

Remarks

[Api set: ExcelApi 1.16]

valueAsJsonBefore

Represents the type of value before the change. Unlike valueBefore, valueAsJsonBefore can represent all cell values, such as formatted number, web image, and entity data types.

valueAsJsonBefore: CellValue;

Property Value

Excel.CellValue

Remarks

[Api set: ExcelApi 1.16]

valueBefore

Represents the value before the change. The data returned could be a string, number, or Boolean. Cells that contain an error will return the error string.

valueBefore: any;

Property Value

any

Remarks

[Api set: ExcelApi 1.9]

valueTypeAfter

Represents the type of value after the change.

valueTypeAfter: Excel.RangeValueType | "Unknown" | "Empty" | "String" | "Integer" | "Double" | "Boolean" | "Error" | "RichValue";

Property Value

Excel.RangeValueType | "Unknown" | "Empty" | "String" | "Integer" | "Double" | "Boolean" | "Error" | "RichValue"

Remarks

[Api set: ExcelApi 1.9]

valueTypeBefore

Represents the type of value before the change.

valueTypeBefore: Excel.RangeValueType | "Unknown" | "Empty" | "String" | "Integer" | "Double" | "Boolean" | "Error" | "RichValue";

Property Value

Excel.RangeValueType | "Unknown" | "Empty" | "String" | "Integer" | "Double" | "Boolean" | "Error" | "RichValue"

Remarks

[Api set: ExcelApi 1.9]