1、增加一个导出按钮(点击执行Button1_Click1),并后台加入如下代:
protected void Button1_Click1(object sender, EventArgs e)
{
Export("application/ms-excel", "记录表.xls");
}
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName,Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
GridView1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
注:需要在引用中增加:
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
2、在GridView中增加下面一些代码即可指定导出数据为文本格式。
GridView1.Attributes.Add("style", "vnd.ms-excel.numberformat:@");
如下图示:
下面是常用的一些格式:
1)文本:vnd.ms-excel.numberformat:@
2)日期:vnd.ms-excel.numberformat:yyyy/mm/dd
3)数字:vnd.ms-excel.numberformat:#,##0.00
4)货币:vnd.ms-excel.numberformat:¥#,##0.00
5)百分比:vnd.ms-excel.numberformat: #0.00%
2、