如何以excel格式导出gridview [英] How to export gridview in excel format

问题描述

我有两个页眉和一个页脚的gridview，我试图将gridview导出为ex​​cel格式但导出后它不会显示页眉和页脚，它只显示记录



我尝试过：

I have gridview with two header and one footer and I am trying to export gridview to excel format but after exporting it will not show header and footer and it only show records

What I have tried:

public void ExportGridToExcel(GridView Grd1,string Filename)
        {
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.ClearContent();
            HttpContext.Current.Response.ClearHeaders();
            HttpContext.Current.Response.Charset = "";
            string FileName = "FileName" + DateTime.Now + ".xls";
            StringWriter strwritter = new StringWriter();
            HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
            HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=" + Filename);
            Grd1.GridLines = GridLines.Both;
            Grd1.HeaderStyle.Font.Bold = true;
            Grd1.RenderControl(htmltextwrtter);
            HttpContext.Current.Response.Write(strwritter.ToString());
            HttpContext.Current.Response.End();
}

推荐答案

按照理查德在评论中的建议。如果没有，我们必须看看页眉和页脚是什么样的，因为我已经完成了你想做的事情。

Do as Richard suggested in the comments. If not, we'd have to see what the headers and footers look like because I've done what you are trying to do.

这篇关于如何以excel格式导出gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！