C# 结合Microsoft.Office.Interop.Excel写入Excel

using System.Reflection;using Microsoft.Office.Interop.Excel;protected void Page_Load(object sender, EventArgs e){    Application app = new Application();    //加载模板    Workbook workbook = app.Workbooks.Open(Server.MapPath("~/Template.xlt"),         Missing.Value, Missing.Value,Missing.Value, Missing.Value,        Missing.Value, Missing.Value, Missing.Value, Missing.Value,        Missing.Value, Missing.Value, Missing.Value,         Missing.Value, Missing.Value, Missing.Value);             try    {       //获取模板中第一个sheet页        Worksheet worksheet = workbook.Sheets.get_Item(1) as Worksheet;       //向Excel单元格填充数据        worksheet.Cells[2, 1] = "66";       worksheet.Cells[2, 2] = "24";       worksheet.Cells[2, 3] = "女";       worksheet.Cells[3, 1] = "lulu";       worksheet.Cells[3, 2] = "20";       worksheet.Cells[3, 3] = "男";       //利用公式计算满足某条街的总和，单独分出3是为了可以在程序中替换该值        worksheet.Cells[2, 4] = "=COUNTIF(C2:C" + 3 + ",\"男\")";       //在结尾添加一特殊行，插入值        Range range = worksheet.get_Range(worksheet.Cells[4, 1], worksheet.Cells[4, 2]);       //合并单元格        range.Merge(0);       //设置单元格文字对齐方式        range.HorizontalAlignment = XlHAlign.xlHAlignRight;       range.Cells[1, 1] = "Hello";       orksheet.Cells[4, 3] = "0";       //设置单元格背景色        range = worksheet.Cells[4, 3] as Range;       range.Interior.Color = System.Drawing.Color.LightSeaGreen;       //画边框        range = worksheet.get_Range(worksheet.Cells[4, 1], worksheet.Cells[4, 3]);       range.Borders.get_Item(XlBordersIndex.xlEdgeTop).LineStyle = XlLineStyle.xlContinuous;       range = worksheet.get_Range(worksheet.Cells[2, 2], worksheet.Cells[3, 2]);       range.Borders.get_Item(XlBordersIndex.xlEdgeRight).LineStyle = XlLineStyle.xlContinuous;       //保存        workbook.SaveAs(Server.MapPath("~/Test.xls"),        Missing.Value, Missing.Value, Missing.Value,Missing.Value,       Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value,        Missing.Value, Missing.Value, Missing.Value, Missing.Value);    }    finally    {        //资源清理        workbook.Close();        app.Quit();    }}