asp.net导出Excel打开的时候提示格式与文件扩展名指定的格式不一致
求大神解答!!!!!!!!
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();
}