GridView导出的EXCEL,可以冻结表头吗
我用下面的代码,实现的Gridview导出EXCEL,由于数据比较多,客户要求打印EXCEL的时候,表头是固定的,也就是在下一页还显示表头,请问一下,有什么办法可以实现吗
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", "attachment;filename="明细表".xls");
Response.ContentEncoding = System.Text.Encoding.UTF8;
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);
GirdSumOut.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();