如何将gridview导出为ex​​cel？ [英] How to export gridview to excel ?

问题描述

Response.Write("Export to excel");
        Response.Clear();
        Response.Charset = "";
        
        Response.ContentType = "application/vnd.ms-excel";
        Response.AddHeader("content-disposition", "attachment;filename=Demo.xls");
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        StringWriter stringwriter = new StringWriter();
        HtmlTextWriter htmwrite = new HtmlTextWriter(stringwriter);
        GridView1.RenderControl(htmwrite);
        Response.Write(stringwriter.ToString());
        Response.End();

This  is my code to export gridview to excel. but an error is shown as
Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server.
Pls help me to correct this

推荐答案

代码项目 - 常见问题系列1：ASP.Net GridView [ ^ ]应该帮助你。

检查你的设计代码，

将gridview1放在表单标签或ContentPlaceholder中，使用runat =Server

您可以使用另一个工具将gridview导出到Excel并使用相同的Formate

导出到Excel

reffer：

http://www.dotnetspider.com/resources/42697-Export-Gridview-Excel-asp-net-c.aspx [ ^ ]

reffer:
http://www.dotnetspider.com/resources/42697-Export-Gridview-Excel-asp-net-c.aspx[^]

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