Create Excel report

        private Application myExcel = null;
        private Workbook myWorkbook;
 
 public void CreateDailyReport()
        {
            string fileTemplate = "SSQLDailyReport.$d.$t.xls";
            XmlTextReader reader = new XmlTextReader(myAppSettings["DailyXMLFilePath"]);
            myReportConfig.ReadXml(reader);

            myAuditLogger.logAuditMessage("Creat new excel document for SSQL Daily Report.");
            myExcel = new Excel.Application();
            if (myExcel == null)
            {
                myAuditLogger.logAuditMessage("Error : Excel can not be started!");
                return;
            }
            Workbooks workbooks = myExcel.Workbooks;
            myWorkbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            Sheets sheets = myWorkbook.Worksheets;

            try
            {
                #region generate the daily summary report
                Worksheet summarySheet = (Worksheet)sheets.get_Item(1);
                LogWorkSheet(summarySheet, "Daily Summary");
                sheets.Add(Type.Missing, summarySheet, 1, Type.Missing);
                myAuditLogger.logAuditMessage("Start to generate Daily Summary Report...");
                CreateReportHeader("Daily", "SUMMARY", myEodDate, summarySheet);
                foreach (DataRow dr in myReportConfig.Tables["Part"].Rows)
                    CreateDailySummary(dr["Name"].ToString(), dr["Type"].ToString(), myReportConfig.Tables["Item"].Select(string.Format("Part_Id = {0}", Convert.ToInt32(dr["Part_Id"]))), summarySheet);
                CreateDailyReviw(summarySheet);
                myAuditLogger.logAuditMessage("Generate Daily Summary Report successfully!");
                #endregion

                #region generate daily detail reports
                int sheetCount = 1;

                foreach (DataRow dr in myReportConfig.Tables["Part"].Rows)
                {
                    if (dr["Name"].ToString() == "Support AdHoc" || dr["Type"].ToString() == "S")
                    {
                        Worksheet sheet = (Worksheet)sheets.get_Item(++sheetCount);
                        if (dr["Name"].ToString() == "ScratchPad")
                            LogWorkSheet(sheet, string.Format("Details ({0}-W)", dr["Name"].ToString()));
                        else
                            LogWorkSheet(sheet, string.Format("Details ({0})", dr["Name"].ToString()));
                        if (sheetCount <= (myReportConfig.Tables["Part"].Select("Name = 'Support AdHoc'").Length + myReportConfig.Tables["Part"].Select("Type = 'S'").Length))
                            sheets.Add(Type.Missing, sheet, 1, Type.Missing);

                        index = 0;
                        if (dr["Name"].ToString() == "ScratchPad")
                            CreateReportHeader("Daily", string.Format("DETAIL FOR {0}-W", dr["Name"].ToString().ToUpper()), myEodDate, sheet);
                        else
                            CreateReportHeader("Daily", string.Format("DETAIL FOR {0}", dr["Name"].ToString().ToUpper()), myEodDate, sheet);
                        CreateDailyDetail(dr["Name"].ToString(), dr["Type"].ToString(), myReportConfig.Tables["Item"].Select(string.Format("Part_Id = {0} and Detail = 'T'", Convert.ToInt32(dr["Part_Id"]))), sheet);
                        myExcel.ActiveWindow.DisplayGridlines = false;
                    }
                }
                #endregion

                myReportPath += myAuditLogger.ProduceFileName(fileTemplate);
                summarySheet.Activate();
                myWorkbook.Close(true, myReportPath, Missing.Value);
                OurDiagnostics.LogInfo("The report file path is " + myReportPath);
            }
            finally
            {
                System.Runtime.InteropServices.Marshal.ReleaseComObject(myWorkbook);
                System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel);
            }
        }