读书人

GridView导出到Excel只导出某些特定

发布时间: 2012-02-02 23:57:14 作者: rapoo

GridView导出到Excel,只导出某些特定列怎么做?
导出代码如下:

Response.ClearContent();
//Response.AddHeader( "content-disposition ", "attachment; filename=MyExcelFile.xls ");
Response.AddHeader( "content-disposition ", "attachment; filename=test.xls ");
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ");//设置输出流为简体中文
Response.ContentType = "application/excel ";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
//gvData.Columns[1].Visible = false;
gvData.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();

比如第一列代码 不想导出怎么办?
谢谢各位指点

[解决办法]
SF
[解决办法]
gridview.columns[0].visible = false;
[解决办法]

就是对GridView进行列操作啊,可以用代码隐藏/删除列,再下载...

读书人网 >asp.net

热点推荐