// Close out the application
private void CloseExcelApplication(bool View)
{
if (excelApp != null)
{
if (View)
{
// Set the Verify worksheet as active
wsVerify.Activate();
// Make a table out of the Verify data
Excel.Range SourceRange = (Excel.Range)wsVerify.get_Range("A1", $"J{wsVerifyRow - 1}");
SourceRange.Worksheet.ListObjects.Add(Excel.XlListObjectSourceType.xlSrcRange,
SourceRange, System.Type.Missing, Excel.XlYesNoGuess.xlYes, System.Type.Missing).Name = "Verify";
SourceRange.Worksheet.ListObjects["Verify"].TableStyle = "TableStyleMedium2";
wsVerify.Columns.AutoFit();
// Set the Traffic worksheet as active
wsTraffic.Activate();
// Make a table out of the traffic data
SourceRange = (Excel.Range)wsTraffic.get_Range("A1", $"N{wsTrafficRow - 1}");
SourceRange.Worksheet.ListObjects.Add(Excel.XlListObjectSourceType.xlSrcRange,
SourceRange, System.Type.Missing, Excel.XlYesNoGuess.xlYes, System.Type.Missing).Name = "Traffic";
SourceRange.Worksheet.ListObjects["Traffic"].TableStyle = "TableStyleMedium2";
wsTraffic.Columns.AutoFit();
// Save it away
TrafficFileName = EIP.CreateFileName(TrafficFolder, "Traffic", "xlsx");
excelApp.ActiveWorkbook.SaveAs(TrafficFileName);
}
wsVerify = null;
wsTraffic = null;
wb.Close();
excelApp.Quit();
Marshal.ReleaseComObject(wb);
Marshal.ReleaseComObject(excelApp);
wb = null;
excelApp = null;
}
}
