数据导出到excel

 public void ExportToExcel()
        {
            // DataTable dt = MySqlHelper.ExecuteDataTable(connStr, string.Format("select ts.mac,ts.score,tn.device_status from test_score ts LEFT JOIN test_now tn on ts.mac=tn.mac where ts.test_id={0} and ts.caiji_time=DATE_SUB(NOW(),INTERVAL 2 SECOND) group by ts.mac,ts.caiji_time", mw.TestNumberTBK.Text), new MySqlParameter[] { });

            //System.Data.DataTable dt = new System.Data.DataTable(); 

//查询数据

            System.Data.DataTable dt = MySqlHelper.ExecuteDataTable(connStr, string.Format("SELECT ts.create_time,ts.caiji_time,ts.mac,ts.score,th.hard_id,tu.address,tu.income,tu.user_age,tu.user_edu,tu.user_job,tu.user_name,tu.user_sex from test_score ts LEFT JOIN test_hard th ON ts.mac=th.mac LEFT JOIN test_user_bind tub ON ts.test_id=tub.test_id AND th.hard_id=tub.hard_id LEFT JOIN test_user tu on tub.HUMAN_id=tu.HUMAN_id where ts.test_id={0}&