【元旦送分】GridView 导到 Excel , 如何添加表头标题列和单位名称，还有填报日期列？？？

o07 2006-12-31 10:52:39

public static void ExportToExcel(string Filename, GridView gridview, Page page)
{
page.Response.Clear();
// 防止中文内容为乱码
page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
//可令中文文件名不为乱码
page.Response.AppendHeader("content-disposition", "attachment;filename=\"" + System.Web.HttpUtility.UrlEncode(Filename + DateTime.Now.ToShortDateString(), System.Text.Encoding.UTF8) + ".xls\"");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridview.RenderControl(htw);
page.Response.Write(sw.ToString());
page.Response.End();
}

+++++++++++++++++++++++++++++++++++++++++++

以上不能创建表头标题列和单位名称，还有填报日期列？

怎么解决呢

例：
某年某月某单位统计表
单位：某某部填写日期:2006-12
-----------------------------------------------
下面才是GridView 的内容

...全文

681 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

wuyongbiao 2007-03-13

打赏
举报

学习

anison 2007-03-05

打赏
举报

mark

wbqsln 2007-03-05

打赏
举报

學習一下

o07 2006-12-31

打赏
举报

十分感谢

用了你在贴子中的回复解决了，Thanks..

也顺祝兄弟节日快乐。

lovehongyun 2006-12-31

打赏
举报

学习`

cpp2017 2006-12-31

打赏
举报

if (e.Row.RowType == DataControlRowType.Header) { GridView gv = (GridView)sender; GridViewRow rowHeader = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); rowHeader.Font.Bold = true; TableCellCollection cells = e.Row.Cells; TableCell headerCell = new TableCell(); headerCell = new TableCell(); headerCell.Text = "某年某月某单位统计表"; headerCell.ColumnSpan = 3; headerCell.HorizontalAlign = HorizontalAlign.Center; rowHeader.Cells.Add(headerCell); rowHeader.CssClass = "rowHeader"; rowHeader.Visible = true; gv.Controls[0].Controls.AddAt(0, rowHeader); rowHeader = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal); rowHeader.Font.Bold = true; cells = e.Row.Cells; headerCell = new TableCell(); headerCell = new TableCell(); headerCell.Text = "单位：某某部"; headerCell.ColumnSpan = 2; headerCell.HorizontalAlign = HorizontalAlign.Center; rowHeader.Cells.Add(headerCell); headerCell = new TableCell(); headerCell.Text = " 填写日期:2006-12"; headerCell.ColumnSpan = 1; headerCell.HorizontalAlign = HorizontalAlign.Center; rowHeader.Cells.Add(headerCell); rowHeader.CssClass = "rowHeader"; rowHeader.Visible = true; gv.Controls[0].Controls.AddAt(1, rowHeader); }

lovcal 2006-12-31

打赏
举报

学习……

zdyguilong 2006-12-31

打赏
举报

接分，学习一下，顺便帮顶

o07 2006-12-31

打赏
举报

cpp2017 2006-12-31

打赏
举报

<div id="div1" runat="server" > 某年某月某单位统计表单位：某某部填写日期:2006-12 ----------------------------------------------- 下面才是GridView 的内容 </div> div1.RenderControl(htw);