private void GenerateAttachment1(DataTable DT)
{
    try
    {
        Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
        if (app == null)
        {
            untCommon.InfoMsg("服務(wù)器上缺少Excel組件，需要安裝Office軟件后重試");
            return;
        }
        app.Visible = false;
        app.UserControl = true;

        string strTempPath = @"D:\!ZhengkuiD\Defence\DefenceMgr\bin\Debug\goodExcel\Old\XXXX.xlsx";  //模板Excel文件的路徑
        Microsoft.Office.Interop.Excel.Workbooks workbooks = app.Workbooks;
        Microsoft.Office.Interop.Excel._Workbook workbook = workbooks.Add(strTempPath); //加載模板
        Microsoft.Office.Interop.Excel.Sheets sheets = workbook.Sheets;
        Microsoft.Office.Interop.Excel._Worksheet worksheet = (Microsoft.Office.Interop.Excel._Worksheet)sheets.get_Item(1); //第一個工作薄
        if (worksheet == null)  //工作薄中沒有工作表
        {
            return;
        }

        //1、獲取數(shù)據(jù)
        int rowCount = DT.Rows.Count;
        if (rowCount <= 0)
            return;

        //2、寫入數(shù)據(jù)，Excel索引從1開始
        for (int i = 1; i <= rowCount; i++)
        {
            int row_ = 0;
            row_ = 3 + i;  //Excel模板上隱藏標(biāo)題、表頭和標(biāo)題行共占3行,根據(jù)實際模板需要修改

            int dt_row = i - 1; //dataTable的行是從0開始的 

            //開始賦值
            worksheet.Cells[row_, 1] = i.ToString();
            worksheet.Cells[row_, 2] = DT.Rows[dt_row]["Name"].ToString();
        }

        //3、保存生成的Excel文件
        string savePath = @"D:\!ZhengkuiD\Defence\DefenceMgr\bin\Debug\goodExcel\New\XXXX.xlsx";
        workbook.SaveAs(savePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

        shuzi++;

        //4、按順序釋放資源
        NAR(worksheet);
        NAR(sheets);
        NAR(workbook);
        NAR(workbooks);
        app.Quit();
        NAR(app);
    }
    catch (Exception)
    {

    }
}