public void SaveStatusToReport() { try { logger.Debug("------|Start To Save Status To Report File"); string SuiteName = Path.GetFileName(InitializeParamter.DataDriverFile); string CaseName = BusinessFlows.CaseName; string StartTime = BusinessFlows.StartTime; DataTable report = new DataTable(); report = DataTableUtility.GetDataTable(); report.Rows.Add(SuiteName, CaseName, status, StartTime, EndTime, ElapsedTime, errorMessage, ScreenShotUtility.finalImageFile); FileInfo newFile = new FileInfo(InitializeParamter.ReportFile); using (ExcelPackage pck = new ExcelPackage(newFile)) { var sheetQuery = from sheet in pck.Workbook.Worksheets where sheet.Name == InitializeParamter.RunDay select sheet; if (sheetQuery.Count() == 0) { ExcelWorksheet ws = pck.Workbook.Worksheets.Add(InitializeParamter.RunDay); ws.Cells["A1"].LoadFromDataTable(report, true); pck.Save(); } else { sheetQuery.First().Cells["A1"]. LoadFromDataTable(report, true); pck.Save(); } } } catch (Exception e) { logger.Fatal("Fail To Save Status To Report"); logger.Fatal(e.Message); } }