Excel.WorksheetFormatChangedEventArgs interface

提供有关工作表格式更改事件的信息。Provides information about the worksheet format change event.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

属性

address

获取区域地址,该地址表示特定工作表上的更改区域。Gets the range address that represents the changed area of a specific worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

source

获取事件源。Gets the source of the event. 有关详细信息,请参阅 Excel.EventSource。See Excel.EventSource for details.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

type

获取事件的类型。Gets the type of the event. 有关详细信息,请参阅 Excel.EventType。See Excel.EventType for details.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

worksheetId

获取其中的数据发生更改的工作表的 ID。Gets the id of the worksheet in which the data changed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

方法

getRange(ctx)

获取区域,该区域表示特定工作表上的更改区域。Gets the range that represents the changed area of a specific worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

getRangeOrNullObject(ctx)

获取区域,该区域表示特定工作表上的更改区域。Gets the range that represents the changed area of a specific worksheet. 它可能会返回 null 对象。It might return null object.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

属性详细信息

address

获取区域地址,该地址表示特定工作表上的更改区域。Gets the range address that represents the changed area of a specific worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

address: string;

属性值

string

source

获取事件源。Gets the source of the event. 有关详细信息,请参阅 Excel.EventSource。See Excel.EventSource for details.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

source: Excel.EventSource | "Local" | "Remote";

属性值

Excel.EventSource | "Local" | "Remote"

type

获取事件的类型。Gets the type of the event. 有关详细信息,请参阅 Excel.EventType。See Excel.EventType for details.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

type: "WorksheetFormatChanged";

属性值

"WorksheetFormatChanged"

worksheetId

获取其中的数据发生更改的工作表的 ID。Gets the id of the worksheet in which the data changed.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

worksheetId: string;

属性值

string

方法详细信息

getRange(ctx)

获取区域,该区域表示特定工作表上的更改区域。Gets the range that represents the changed area of a specific worksheet.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

getRange(ctx: Excel.RequestContext): Excel.Range;

参数

返回

getRangeOrNullObject(ctx)

获取区域,该区域表示特定工作表上的更改区域。Gets the range that represents the changed area of a specific worksheet. 它可能会返回 null 对象。It might return null object.

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

getRangeOrNullObject(ctx: Excel.RequestContext): Excel.Range;

参数

返回