C#做得网站中导出到Excel表格颜色问题
来源:百度知道 编辑:UC知道 时间:2024/05/30 20:59:03
我的C#网站导出为Excel后,表格的颜色设置不太令人满意,想在导出的过程中或者导出后改下表格颜色,以下是导出的代码,请明白人看下,应该怎么做
//导出为EXCEL
protected void Button2_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
//输出类型为Excel
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlPathEncode("物品存储及更改表.xls"));
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = "Word文档";
this.EnableViewState = false;
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
this.GridView1.AllowPaging = false;
this.GridView1.DataBind();
this.GridView1.RenderControl(oHtm
//导出为EXCEL
protected void Button2_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
//输出类型为Excel
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlPathEncode("物品存储及更改表.xls"));
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Charset = "Word文档";
this.EnableViewState = false;
StringWriter oStringWriter = new StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
this.GridView1.AllowPaging = false;
this.GridView1.DataBind();
this.GridView1.RenderControl(oHtm
一楼说的是。
RenderControl用的就是你的gridview的格式,你想要什么颜色在把gridview设置好就行了,导出后和gridview一样。
由代码可以看出,数据的导出格式是根据gridView的设定而生成的,如果你把gridView设定为你想要的格式,可能会实现你的要求。
我也是来学习的。
我也期待着,这个问题。。。