public static void DataTableToExcel(System.Data.DataTable dt, string saveFileName)

        {

            try

            {

                if (dt == null) return;

                //-***************获取excel对象***************

                //  string saveFileName = "";

                TimeSpan dateBegin = new TimeSpan(DateTime.Now.Ticks);

                bool fileSaved = false;

                SaveFileDialog saveDialog = new SaveFileDialog();

                saveDialog.DefaultExt = "xls";

                saveDialog.Filter = "Excel文件|*.xls";

                saveDialog.FileName = saveFileName+"数据导出结果 " + DateTime.Today.ToString("yyyy-MM-dd");

                saveDialog.ShowDialog();

                saveFileName = saveDialog.FileName;

                if (saveFileName.IndexOf(":") < 0) return; //被点了取消            

                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();

                if (xlApp == null)

                {

                    MessageBox.Show("无法启动Excel，可能您未安装Excel");

                    return;

                }

                Microsoft.Office.Interop.Excel.Workbook workbook = xlApp.Workbooks.Add(true);

                Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];

                Microsoft.Office.Interop.Excel.Range range;





                // string oldCaption = dt.CaptionText;