public void SaveAndClose(string path) { if (workbook != null) { workbook.SaveAs(path); workbook.Close(); Marshal.FinalReleaseComObject(workbook); workbook = null; workbooks.Close(); Marshal.FinalReleaseComObject(workbooks); workbooks = null; } if (excel != null) { excel.Application.Workbooks.Close(); excel.Application.Quit(); excel.Quit(); Marshal.FinalReleaseComObject(excel.Application); Marshal.FinalReleaseComObject(excel); excel = null; } GC.Collect(); GC.WaitForPendingFinalizers(); }
public ExcelTakeout(string Basepath) { wbs = app.Workbooks; string newFilePath = Basepath + "\\" + NEW_FILE_NAME; try { wb = wbs.Open(newFilePath); wss = wb.Worksheets; ws = wss.Item[NEW_SHEET_NAME]; } catch (Exception e) { Console.WriteLine(e); wbs.Close(); } }