Workbook.SheetRemoved Event

Occurs after a worksheet has been removed from a workbook.

You require a license to the DevExpress Office File API or DevExpress Universal Subscription to use this event in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v19.1.dll

Declaration

C#

public event SheetRemovedEventHandler SheetRemoved

VB.NET

Public Event SheetRemoved As SheetRemovedEventHandler

Event Data

The SheetRemoved event's data class is SheetRemovedEventArgs.

Remarks

Handle the SheetRemoved event to perform specific actions each time a worksheet is deleted using the WorksheetCollection.Remove or WorksheetCollection.RemoveAt methods.

When a worksheet is removed from the workbook, the Workbook.ActiveSheetChanged event fires first, and the SheetRemoved event fires next. The Workbook.ActiveSheetChanging event does not occur.

Note

This event does not occur by default. The event fires only if the WorkbookEventOptions.RaiseOnModificationsViaAPI property is true.

Implements

SheetRemoved