把DataTable用Excel形式导出

public static void CreateExcel(Page page,DataTable mydt,string FileName) { HttpResponse resp; resp = page.Response; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName); string colHeaders= "", ls_item=""; int i=0; //定义表对象与行对像，同时用DataSet对其值进行初始化 DataTable dt=mydt; DataRow[] myRow=dt.Select(""); //取得数据表各列标题，各标题之间以/t分割，最后一个列标题后加回车符 for(i=0;i