GrapeCity.Documents.Excel.IWorkbook.SheetBeforeDelete

SheetBeforeDelete Event

Occurs before a sheet is deleted.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

event EventHandler<SheetEventArgs> SheetBeforeDelete

Event SheetBeforeDelete As EventHandler(Of SheetEventArgs)

Returns

Type	Description
EventHandler<SheetEventArgs>	Occurs before a sheet is deleted.

Examples

IWorksheet sheetToDelete = workbook.Worksheets.Add();
IWorksheet sheetFromEvent = null;
workbook.SheetBeforeDelete += (sender, e) =>
{
    sheetFromEvent = e.Sheet;
};
sheetToDelete.Delete();
IWorksheet deletedSheet = sheetFromEvent;