如何在asp.net中将gridview数据导出为ex​​cel [英] How to export gridview data to excel in asp.net

问题描述

你好朋友..

我希望代码将数据导出到excel ..请帮助我..

提前谢谢..

Hello friends..
I want code to export data to excel..please help me..
Thanks in advance..

推荐答案

在文章中搜索你有解决方案......研究它

将Gridview数据导出到ASP.NET中的Excel [ ^ ]

http://www.aspdotnet-suresh.com/2011/04 /how-to-export-gridview-data-to-excel-or.html [ ^ ]

search in article u have solution for this...... study it
Export Gridview Data to Excel in ASP.NET[^]
http://www.aspdotnet-suresh.com/2011/04/how-to-export-gridview-data-to-excel-or.html[^]

导出到Excel [ ^ ]

GridView - Export到Excel [ ^ ]

网格视图导出到Excel [ ^ ]

将Gridview内容导出到Excel [ ^ ]

如何将GridView导出到Excel，渲染单元格，添加艺术字和填写自定义模板 [ ^ ]可能有帮助。



..还看看类似的答案

将gridview导入excel文件 [ ^ ]

Export To Excel[^]
GridView - Export to Excel[^]
Grid View Export To Excel[^]
Export Gridview Contents into Excel[^]
How to export GridView to Excel, render cells, add WordArt, and fill a custom template[^] might help.

..and also have a look on similar answer
export gridview into excel file[^]

：

on aspx page:

<asp:linkbutton id="lnkExporttoExcel" runat="server" causesvalidation="false" cssclass="link" onclientclick="return confirm('Are you sure you want to export this report to excel?');" onclick="OnLnkExportToExcelClick" xmlns:asp="#unknown">Export to Excel</asp:linkbutton>

和.cs页面：

and on .cs page :

 protected void OnLnkExportToExcelClick(object sender, EventArgs e)
        {
       
 Response.Clear();
                Response.AddHeader("content-disposition", "attachment;filename=CodeProjectExcelHelp_Report.xls");
                Response.Charset = "iso-8859-2";
                Response.ContentType = "application/ms-excel";
               
                using (StringWriter StringWriter = new System.IO.StringWriter())
                {
                    using (HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter))
                    {
                        grdUserTaskDetails.AllowPaging = false;//grdUserTaskDetails is my gridview name
                        grdUserTaskDetails.Attributes.AddAttributes(HtmlTextWriter);
                        GetUserTaskDetails();//get your data here
                        MergeRows(grdUserTaskDetails);//formate your repeated rows
                        grdUserTaskDetails.RenderControl(HtmlTextWriter);
                      }
                    string str = "User E-mail Id : " + User.Identity.Name + "<br />" + "Start Date : " + startDate.ToString("dd/MM/yyyy") + "<br /> End Date : " + endDate.ToString("dd/MM/yyyy") + "<br />";
                    Response.Write(str);
                    Response.Write(StringWriter.ToString());
}

public override void VerifyRenderingInServerForm(Control control)
       {
           /* Verifies that a Form control was rendered */
       }

谢谢

JMD

thanks
JMD

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