将GridView导出到Excel而不丢失excel doc中的行数

本文是小编为大家收集整理的关于将GridView导出到Excel而不丢失excel doc中的行数的处理/解决方法，可以参考本文帮助大家快速定位并解决问题，中文翻译不准确的可切换到English标签页查看源文。

中文
English

问题描述

string attachment = "attachment; filename=Contacts.xls";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);     

        HtmlForm frm = new HtmlForm();           

        GridView1.Parent.Controls.Add(frm);
        frm.Attributes["runat"] = "server";
        frm.Controls.Add(GridView1);
        frm.RenderControl(htw);        
        Response.Write(sw.ToString());
        Response.End();

上述代码将网格数据导出到excel，但不显示excel的单元格.

解决方案

你可以使用这个工具
exporttoexcel

您好，

使用下面的链接导出到 Excel.它是先进的，并通过用户定义的设计给出了适当的结果.

从C#中的GridView导出到Excel[^]

这是我写的，如果你有任何疑问可以写信给我.

你好，

查看这个[^]...

本文地址：https://www.itbaoku.cn/post/1394787.html

百度翻译此文有道翻译此文

问题描述

string attachment = "attachment; filename=Contacts.xls";
        Response.ClearContent();
        Response.AddHeader("content-disposition", attachment);
        Response.ContentType = "application/ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);     

        HtmlForm frm = new HtmlForm();           

        GridView1.Parent.Controls.Add(frm);
        frm.Attributes["runat"] = "server";
        frm.Controls.Add(GridView1);
        frm.RenderControl(htw);        
        Response.Write(sw.ToString());
        Response.End();

The above code exports grid data into excel but not displays cells of excel.

推荐答案

You can use this Tool
exporttoexcel

Hi,

Use below link for export to Excel. It is advance and gives proper result with user defined design.

Export to Excel from GridView in C#[^]

It is written by me, if you have any query then you can write to me.

Hi,

Check out this[^]...

查看全文

上一篇：从数据表中获取最大日期

下一篇：在windows下编译sflowtool的源代码