在asp.net和c＃中将Gridview导出到Excel [英] Export Gridview to Excel in asp.net and c#

问题描述

你好

我不知道出口gridview要excel，请帮我

解决方案

将网格导出到PDF / Excel

第1步：

public override void VerifyRenderingInServerForm（Control control）{}



第2步：PDF
public void imgPDFExport_Click（object sender，ImageClickEventArgs e）

{

// gl.Bindgridview（PGetByExperience，@ banner，Get ，gridName）;

Response.ContentType =application / pdf;

Response.AddHeader（content-disposition，attachment; filename = UserDetails.pdf）;

Response.Cache.SetCacheability（HttpCacheability.NoCache）;

StringWriter sw = new StringWriter（）;

HtmlTextWriter hw = new HtmlTextWriter（sw）;

gridName.AllowPaging = false;

gridName.DataBind（）;

gridName.RenderControl（hw）;

StringReader sr = new StringReader（sw.ToString（））;

文件pdfDoc =新文件（PageSize.A2,7f，7f，7f，0f）;

HTMLWorker htmlparser = new HTMLWorker（pdfDoc）;

PdfWriter.GetInstance（pdfDoc，Response.OutputStream）;

pdfDoc.Open（）;

htmlparser.Parse（sr）; pdfDoc.Close（）;

Response.Write（pdfDoc）;

Response.End（）;

}

第3步：Excel

public void imgExcelExport_Click（object sender，ImageClickEventArgs e）

{

ShowData（）;

Response.ClearContent（）;

Response.Buffer = true;

Response.AddHeader（content-disposition，string.Format（attachment; filename = {0}，Customers.xls））;

Response.ContentType =application / ms-excel;

StringWriter sw = new StringWriter（）;

HtmlTextWriter htw = new HtmlTextWriter（sw）;

gridName.AllowPaging = false; gridName.DataBind（）;

gridName.HeaderRow.Style.Add（background-color，＃FFFFFF）;

gridName.RenderControl（htw）;

Response.Write（sw.ToString（））;

Response.End（）;

}



Mahesh Suryawanshi Pune

有很多例子，谷歌吧。



简单的例子，在图片中：http：//www.gridview.net/export-datagridview-to -excel-in-c /



这种方式只有可能出现的问题：

1.必须安装Microsoft Office

2.如果CurrentCulture不是EN-US，有时会出现错误，但您可以在创建文件之前更改它并在之后再次恢复。

以下是导出数据的另一种方法通过启用excel的默认排序和过滤列来实现卓越。我们还有控件来设置工作表名称。所有这一切都可以在不使用Interop的情况下实现。



这是链接

http://blog.weareon.net/export-datatable-to-excel-in- asp-net-without-using-excel-interop-part-ii [ ^ ]



希望这有帮助

Hello
I dont have idea on export gridview to excel,pls help me

解决方案

Export Grid To PDF / Excel
Step 1:
public override void VerifyRenderingInServerForm(Control control) { }

Step 2: PDF
public void imgPDFExport_Click(object sender, ImageClickEventArgs e)
{
// gl.Bindgridview("PGetByExperience", "@flag", "Get", gridName);
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=UserDetails.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gridName.AllowPaging = false;
gridName.DataBind();
gridName.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfDoc = new Document(PageSize.A2, 7f, 7f, 7f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr); pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
Step 3: Excel
public void imgExcelExport_Click(object sender, ImageClickEventArgs e)
{
ShowData();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridName.AllowPaging = false; gridName.DataBind();
gridName.HeaderRow.Style.Add("background-color", "#FFFFFF");
gridName.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}

Mahesh Suryawanshi Pune

There are many examples, google it.

Simple example, "in pictures": http://www.gridview.net/export-datagridview-to-excel-in-c/

This way has only to possible problems:
1. Microsoft Office must be installed
2. Sometimes error appears if CurrentCulture is not "EN-US", but you can change it before creating file and restore again after.

Here is anoher way to export data to excel with enabling excel's default sorting and filtering on columns. also we have the control to set worksheet name. And all this can be achieved without using Interop.

Here is the link
http://blog.weareon.net/export-datatable-to-excel-in-asp-net-without-using-excel-interop-part-ii[^]

Hope this helps

这篇关于在asp.net和c＃中将Gridview导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！