Edit

Share via

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 ]