Question

asp.net gridview导入到Excel 导出后只有gridview以外的数据，刚好没有gridview中的数据 代码如下：

private void Export(string FileType, string FileName)
{
try
{
Response.Charset = "UTF8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8));
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
this.Gv_Data.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
catch (Exception err)
{
Response.Write("导出Excel出错！错误原因：" + err.Message);

}
}

Answer 1

你的数据源可以使dataset之类的，而不是说非要导出gridview中的数据。就是说你的gridview和导出的数据是同一个数据源就行了。

Answer 2

http://zhidao.baidu.com/question/421954202.html?oldq=1 这个导出 对你有帮助

Answer 3

public override void VerifyRenderingInServerForm(Control control)
{
}
protected void btnExcel_Click(object sender, EventArgs e)
{
Export("application/ms-excel", "学生成绩报表.xls");
}
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition",
"attachment;filename=" +
HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
gvwStudent.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}