从模板创建Excel程序

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Microsoft.Office.Interop.Excel.Application m_objExcel = null;
            Microsoft.Office.Interop.Excel.Workbooks m_objBooks = null;
            Microsoft.Office.Interop.Excel.Workbook m_objBook = null;
            Microsoft.Office.Interop.Excel.Sheets m_objSheets = null;
            Microsoft.Office.Interop.Excel.Worksheet m_objSheet = null;
            Microsoft.Office.Interop.Excel.Range o_NO = null;
            Microsoft.Office.Interop.Excel.Range o_Name = null;
            Microsoft.Office.Interop.Excel.Range o_Tel = null;
            Microsoft.Office.Interop.Excel.Range o_QQ = null;
            Microsoft.Office.Interop.Excel.Range o_Email = null;
            Microsoft.Office.Interop.Excel.Range indexs = null;
            try
            {
                m_objExcel = new Microsoft.Office.Interop.Excel.Application();
                m_objExcel.Visible = false;
                m_objBooks = m_objExcel.Workbooks;
                m_objBooks.Add(true);
                m_objBook = m_objExcel.Workbooks.Add(@"D:T.xlt");
                m_objSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objBook.ActiveSheet;
                m_objExcel.DisplayAlerts = false;
                foreach (Microsoft.Office.Interop.Excel.Name nm in m_objExcel.Names)
                {
                    switch (nm.Name)
                    {
                        case "NO":
                            o_NO = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        case "Name":
                            o_Name = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        case "Tel":
                            o_Tel = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        case "QQ":
                            o_QQ = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        case "Email":
                            o_Email = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        case "index":
                            indexs = m_objExcel.get_Range(nm, Type.Missing);
                            break;
                        default:
                            break;
                    }
                }
                for (int i = 0; i < 5; i++)
                {
                    if (i > 0)
                    {
                        indexs.Rows.EntireRow.Activate();
                        indexs.Rows.EntireRow.Cells.Copy(Type.Missing);
                        indexs.Rows.EntireRow.Insert(Microsoft.Office.Interop.Excel.XlInsertShiftDirection.xlShiftDown, Type.Missing);
                        indexs.Rows.EntireRow.ClearContents();
                    }
                    o_NO.set_Item(Type.Missing, Type.Missing, (i + 1).ToString());
                    o_Name.set_Item(Type.Missing, Type.Missing, "王康");
                    o_Tel.set_Item(Type.Missing, Type.Missing, "138XXXX4349");
                    o_QQ.set_Item(Type.Missing, Type.Missing, "3987223");
                    o_Email.set_Item(Type.Missing, Type.Missing, "Walter.K.Wang@gmail.com");
                }
                m_objExcel.DisplayAlerts = false;

                //保存XLS
                m_objBook.SaveAs(@"D:" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls", 
                             Microsoft.Office.Interop.Excel.XlFileFormat.xlTemplate,
                             Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                             Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing,
                             Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                m_objBook.Close(false, false, Type.Missing);
            }
            catch(Exception Err)
            {
                MessageBox.Show(Err.Message);
            }
            finally
            {
                try
                {
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(o_Email);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(o_QQ);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(o_Tel);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(o_Name);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(o_NO);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheet);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objSheets);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBooks);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
                }
                catch
                {
                    o_Email = null;
                    o_QQ = null;
                    o_Tel = null;
                    o_Name = null;
                    o_NO = null;
                    m_objSheet = null;
                    m_objSheets = null;
                    m_objBook = null;
                    m_objBooks = null;
                    m_objExcel = null;
                }
            }
        }
    }
}