protected void Convert2Excel(string fileName)
{
//设定输入文件流的字符集
this.Response.Charset = "gb2312";
//设定编码方式为UTF7
this.Response.ContentEncoding = Encoding.UTF7;
//设定响应头 即响应中含有附件
this.Response.AppendHeader("Content-Disposition",
string.Format("attachments;filename={0}",
HttpUtility.UrlEncode(fileName,Encoding.UTF8).ToString())
);
//设定响应类型为Excel文件
this.Response.ContentType = "application/ms-excel";
//响应不存储于ViewState中
this.EnableViewState = false;
//实例化字符流写入器
StringWriter writer = new StringWriter();
//实例化Html字符流写入器
HtmlTextWriter hw = new HtmlTextWriter(writer);
//将GridView中所有的数据和格式转化为Html代码并写入至Html字符流写入器
this.GridView1.RenderControl(hw);
//在响应中输出GridView控件的Html代码
this.Response.Write(writer.ToString());
//停止响应
this.Response.End();
}
protected void btnConvert2Excel_Click(object sender, EventArgs e)
{
//输入文件名 导入至Excel文件中
this.Convert2Excel("员工信息.xls");
}