ASP.NET导出到excel

DateTime dtime1 = DateTime.Parse(yf + "-01");
            DateTime dtime2 = dtime1.AddMonths(1);
            string d2 = dtime2.ToString("yyyy年M月");
            string d1 = dtime1.ToString("yyyy年M月");
            string title1 = d1 + "份隐患治理及" + d2 + "份隐患排查情况统计表";
            SeftyAnalyse sefty1 = new SeftyAnalyse();
            IList<Model.yhTjModel> ilist_yhtj = sefty1.HiddenRiskStats(dtime1.Year.ToString(), dtime1.Month.ToString());


            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlApp == null)
            {
                return;
            }
            System.Globalization.CultureInfo CurrentCI = System.Threading.Thread.CurrentThread.CurrentCulture;
            System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
            Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
            Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
            Microsoft.Office.Interop.Excel.Range range;
            worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[1, 22]].MergeCells = true;//合并列
            worksheet.Cells[1, 1] = "2017年8月份隐患治理及2017年9月份隐患排查情况统计表";//单元格赋值
            worksheet.Range[worksheet.Cells[2,1],worksheet.Cells[4,1]].MergeCells = true;
            worksheet.Cells[2, 1] = "单位";
            worksheet.Range[worksheet.Cells[2,2],worksheet.Cells[2,9]].MergeCells = true;
            worksheet.Cells[2, 2] = "2017年8月隐患治理";
            worksheet.Range[worksheet.Cells[2, 10], worksheet.Cells[2, 22]].MergeCells = true;
            worksheet.Cells[2, 10] = "2017年9月隐患排查";
            worksheet.Range[worksheet.Cells[3, 2], worksheet.Cells[3, 3]].MergeCells = true;
            worksheet.Cells[3, 2] = "A级";
            worksheet.Range[worksheet.Cells[3, 4], worksheet.Cells[3, 5]].MergeCells = true;
            worksheet.Cells[3, 4] = "B级";
            worksheet.Range[worksheet.Cells[3, 6], worksheet.Cells[3, 7]].MergeCells = true;
            worksheet.Cells[3, 6] = "C级";
            worksheet.Range[worksheet.Cells[3, 8], worksheet.Cells[3, 9]].MergeCells = true;
            worksheet.Cells[3, 8] = "完成合计";
            worksheet.Range[worksheet.Cells[3, 10], worksheet.Cells[3, 11]].MergeCells = true;
            worksheet.Cells[3, 10] = "顶板";
            worksheet.Range[worksheet.Cells[3, 12], worksheet.Cells[3, 13]].MergeCells = true;
            worksheet.Cells[3, 12] = "防治水";
            worksheet.Range[worksheet.Cells[3, 14], worksheet.Cells[3, 15]].MergeCells = true;
            worksheet.Cells[3, 14] = "通防";
            worksheet.Cells[3, 16] = "机电运输";
            worksheet.Cells[3, 17] = "综合";
            worksheet.Cells[3, 18] = "其他";
            worksheet.Range[worksheet.Cells[3, 19], worksheet.Cells[3, 21]].MergeCells = true;
            worksheet.Cells[3, 19] = "合计";
            worksheet.Cells[3, 22] = "完成";
            worksheet.Range[worksheet.Cells[3, 22], worksheet.Cells[4, 22]].MergeCells = true;
            worksheet.Cells[4, 2] = "排查";
            worksheet.Cells[4, 3] = "治理完成";
            worksheet.Cells[4, 4] = "排查";
            worksheet.Cells[4, 5] = "治理完成";
            worksheet.Cells[4, 6] = "排查";
            worksheet.Cells[4, 7] = "治理完成";
            worksheet.Cells[4, 8] = "排查";
            worksheet.Cells[4, 9] = "治理";
            worksheet.Cells[4, 10] = "A级";
            worksheet.Cells[4, 11] = "B级";
            worksheet.Cells[4, 12] = "A级";
            worksheet.Cells[4, 13] = "B级";
            worksheet.Cells[4, 14] = "A级";
            worksheet.Cells[4, 15] = "B级";
            worksheet.Cells[4, 16] = "B级";
            worksheet.Cells[4, 17] = "B级";
            worksheet.Cells[4, 18] = "B级";
            worksheet.Cells[4, 19] = "A级";
            worksheet.Cells[4, 20] = "B级";
            worksheet.Cells[4, 21] = "C级";
            int z = 5;
            int z1 = ilist_yhtj.Count;
            foreach (var item in ilist_yhtj)
            {
                worksheet.Cells[z, 1] = item.KjName;
                worksheet.Cells[z, 2] = item.A_PC;
                worksheet.Cells[z, 3] = item.A_WC;
                worksheet.Cells[z, 4] = item.B_PC;
                worksheet.Cells[z, 5] = item.B_WC;
                worksheet.Cells[z, 6] = item.C_PC;
                worksheet.Cells[z, 7] = item.C_WC;
                worksheet.Cells[z, 8] = item.PC;
                worksheet.Cells[z, 9] = item.WC;
                worksheet.Cells[z, 10] = item.A_DB;
                worksheet.Cells[z, 11] = item.B_DB;
                worksheet.Cells[z, 12] = item.A_Fzs;
                worksheet.Cells[z, 13] = item.B_Fzs;
                worksheet.Cells[z, 14] = item.A_TF;
                worksheet.Cells[z, 15] = item.B_TF;
                worksheet.Cells[z, 16] = item.B_JD;
                worksheet.Cells[z, 17] = item.B_ZH;
                worksheet.Cells[z, 18] = item.B_QT;
                worksheet.Cells[z, 19] = item.A_HJ;
                worksheet.Cells[z, 20] = item.B_HJ;
                worksheet.Cells[z, 21] = item.C_HJ;
                worksheet.Cells[z, 22] =(item.A_HJ+item.B_HJ+item.C_HJ).ToString();
                z++;
            }
            range = worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[z1+4, 22]];
            range.Borders.LineStyle = XlLineStyle.xlContinuous;//区域内的单元格带边框线
            range.HorizontalAlignment = XlVAlign.xlVAlignCenter;//水平居中
            range.VerticalAlignment = XlVAlign.xlVAlignCenter;//垂直居中
            range.EntireColumn.AutoFit();//自动列宽
            workbook.Close(true, Type.Missing, Type.Missing);