private void OnWorksheetDeleted(WorksheetDeletedEventArgs e)
{
var handler = WorksheetDeleted;
if (handler != null)
{
handler(this, e);
}
}
void Application_SheetActivate(object sh)
{
var ws = sh as Excel.Worksheet;
var wb = ws.Parent as Excel.Workbook;
// A worksheet was closed if a request is pending and the worksheet count decreased
var wasClosed = PendingRequest != null && wb.Worksheets.Count < PendingRequest.WorksheetCount;
if (wasClosed)
{
var args = new WorksheetDeletedEventArgs(PendingRequest.WorksheetName, PendingRequest.WorkbookName);
PendingRequest = null;
OnWorksheetDeleted(args);
}
else
{
PendingRequest = null;
}
}
