DataTable 导出Excel

  private static Boolean ExpordExcel(DataTable dt, string filePath, string ReportTitle, bool isTitle)
        {
            writelog("ExpordExcel 导出资料" );
            if (dt == null || dt.Rows.Count <=0)
            {
                writelog("ExpordExcel 没有资料");
                return false;

            }
            int eRowIndex = 1;
            int eColIndex = 1;
            int cols = dt.Columns.Count;
            int rows = dt.Rows.Count;
            Excel.Application xlApp = new Excel.ApplicationClass();
            Excel.Workbook xlBook = xlApp.Workbooks.Add(true);


            Excel.Worksheet xlWorksheet;

            //xlWorksheet = (Excel.Worksheet)xlBook.Worksheets.Add(Type.Missing, Type.Missing, 1, Type.Missing);//增加
            xlWorksheet = (Excel.Worksheet)xlBook.Worksheets.get_Item(1);//取第一个Sheet

            xlWorksheet.Name = ReportTitle;//表的名
            

            
            try
            {
                //标题的处理
                if (isTitle)