求大神解答!!!!!!!!
public void CreateExcel(DataTable dt, string FileName)
        {
            dt.Columns[0].ColumnName = "序号";
            dt.Columns[1].ColumnName = "姓名";
            dt.Columns[2].ColumnName = "学号";
            dt.Columns[3].ColumnName = "身份证号码";
            dt.Columns[4].ColumnName = "专业";
            dt.Columns[5].ColumnName = "学院";
            dt.Columns[6].ColumnName = "生源地";
            dt.Columns[7].ColumnName = "报到证派遣单位";
            dt.Columns[8].ColumnName = "实际用人单位";
            dt.Columns[9].ColumnName = "单位传真";
            dt.Columns[10].ColumnName = "邮政编码";
            dt.Columns[11].ColumnName = "备注";
            dt.Columns[12].ColumnName = "是否本研";
            dt.Columns[13].ColumnName = "是否国防生,天业定向";
            HttpResponse resp;
            resp = Page.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
            string colHeaders = "", ls_item = "";            //定义表对象与行对象,同时用DataSet对其值进行初始化 
            //DataTable dt = ds.Tables[0];
            DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的
            int i = 0;
            int cl = dt.Columns.Count;            // 取得数据表各列标题,各标题之间以/t分割,最后一个列标题后加回车符 
            for (i = 0; i < cl; i++)
            {
                if (i == (cl - 1))//最后一列,加/n
                {
                    colHeaders += dt.Columns[i].Caption.ToString() + "\r\n";
                }
                else
                {
                    colHeaders += dt.Columns[i].Caption.ToString() + "\t";
                }            }
            resp.Write(colHeaders);
            // 向HTTP输出流中写入取得的数据信息             // 逐行处理数据   
            foreach (DataRow row in myRow)
            {
                //当前行数据写入HTTP输出流,并且置空ls_item以便下行数据     
                for (i = 0; i < cl; i++)
                {
                    if (i == (cl - 1))//最后一列,加/n
                    {
                        ls_item += row[i].ToString() + "\r\n";
                    }
                    else
                    {
                        ls_item += row[i].ToString() + "\t";
                    }                }
                resp.Write(ls_item);
                ls_item = "";            }
            resp.End();
        }