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();
}
}
