Fix corrupted Excel file issue #413

1 files changed, 5 insertions, 0 deletions

diff --git a/sheet.go b/sheet.go
index 951baf9..9e8d504 100644
--- a/sheet.go
+++ b/sheet.go
@@ -406,6 +406,11 @@ func (f *File) DeleteSheet(name string) {
 			f.SheetCount--
 		}
 	}
+	for idx, bookView := range wb.BookViews.WorkBookView {
+		if bookView.ActiveTab >= f.SheetCount {
+			wb.BookViews.WorkBookView[idx].ActiveTab--
+		}
+	}
 	f.SetActiveSheet(len(f.GetSheetMap()))
 }