gridview控件中的内容导出至excel的问题

[chxime]

web窗体中有一个gridview控件ID=“TelephoneView”,我想吧其中的数据导入到excel中，代码如下：
protected void toExcel(object sender, EventArgs e) //导出搜索结果至excel
{ Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=MyExcel2.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
TelephoneView.AllowPaging = false;
TelephoneView.DataBind();
TelephoneView.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
TelephoneView.AllowPaging = true;
}

public override void VerifyRenderingInServerForm(Control control)
{
}
但MyExcel2.xls中什么内容也没有只有一对<div></div>,请高手指点一下我的代码有问题吗？

[chxime]

顶

[hbbdhbbd]

那还是TelephoneView中没内容，你是不是用dataSource了，这样的话，还要加一句datasourceID.selectedCommand="xxx";

[zzxap]

[code=C#]
把dataset数据保存到excel
public void CreateExcel(DataSet ds, 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 = "";
//定义表对象与行对象，同时用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() + "\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() + "\n";
}
else
{
ls_item += row[i].ToString() + "\t";
}
}
resp.Write(ls_item);
ls_item = "";
}
resp.End();
}
[/CODE]