.net中将gridview数据导出到excel中

问题1:
Gridview必须在有runt=sever的窗体标记内
解决办法:
加这样一个方法
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
导出文件扩展名问题:尚未解决;
导出文件内容乱码:
Response.Charset = "";
Response.ContentEncoding = System.Text.Encoding.Unicode;

byte[] rgByteLeader = new byte[] { 0xFF, 0xFE };
Response.BinaryWrite(rgByteLeader);
完整代码

protected void Button1_Click(object sender, EventArgs e)
{
VerifyRenderingInServerForm(GridView1);
ExpertControl(GridView1,"excel","选题信息");
}
public override void VerifyRenderingInServerForm

(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
//导出方法
public void ExpertControl(System.Web.UI.Control source,

string doctype, string docName)
{

Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentEncoding =

System.Text.Encoding.Unicode;
//设置Http的头信息,编码格式
if (doctype == "excel")
{
//Excel
Response.AppendHeader("Content-Disposition",

"attachment;filename=" + HttpUtility.UrlEncode(docName,

System.Text.Encoding.UTF8) + ".xlsx");
Response.ContentType = "application/ms-excel";
}
if (doctype == "word")
{
//Word
Response.AppendHeader("Content-Disposition",

"attachment;filename=" + HttpUtility.UrlEncode(docName,

System.Text.Encoding.UTF8) + ".doc");
Response.ContentType = "application/ms-word";
}
byte[] rgByteLeader = new byte[] { 0xFF, 0xFE };
Response.BinaryWrite(rgByteLeader);
//关闭控件的视图状态
source.Page.EnableViewState = false;
//初始化HtmlWriter
System.IO.StringWriter writer = new

System.IO.StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter

(writer);
source.RenderControl(htmlWriter);
//输出
Response.Write(writer.ToString());
Response.End();
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值