我用这种方式导出Excel ,但没办法设置Excel 的格式
protected void Button1_Click( object sender, System.EventArgs e )
...{
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End(); }
public override void VerifyRenderingInServerForm( Control control )
...{ }
比如我要导出一个条数据是这样1.00 2.00 3.00 4.00
也就是我要导出像货币的类型,后面有加小数,可是导出的结果却是:
1 2 3 4请问要怎样设置导出Excel的格式
protected void Button1_Click( object sender, System.EventArgs e )
...{
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End(); }
public override void VerifyRenderingInServerForm( Control control )
...{ }
比如我要导出一个条数据是这样1.00 2.00 3.00 4.00
也就是我要导出像货币的类型,后面有加小数,可是导出的结果却是:
1 2 3 4请问要怎样设置导出Excel的格式
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);
这两句上,要想太到楼主你想要效果可不可以对GridView1内的数据(字符串)先进行一下格式上的预处理,然后再来导出。纯属个人观点
比如3.00就变成3了
e.Row.Cells[0].Style.Add("mso-number-format", @"\#\,\#\#0\.00_\)\;\\\(\#\,\#\#0\.00\\\);");结果运行好了,可是我早上一打开,又不好了,真不知是什么原因
但是如果我导出用的不是gridview而是表格,那该怎么设置呢?
还请各位大哥再帮小第一把