public void SaveAndCleanUp() { try { if (XLPackage != null) { XLPackage.Save(); XLPackage.Dispose(); XLPackage = null; } } catch (Exception ex) { throw (ex); } Process[] deathList = Process.GetProcessesByName("excel"); try { for (int i = 0; i < deathList.Length; i++) { deathList[i].Close(); //deathList[i].Kill(); } } catch (Exception ex) { throw new ExternalException("There was a problem killing the running excel processes, " + ex.Message, ex); } }
public void Close() { try { if (XLPackage != null) { XLPackage.Dispose(); XLPackage = null; } } catch (Exception ex) { throw (ex); } }