《WebForm开发系列高级篇》Item2导出EXCEL通用类(GridView,DataList,Repeater,DetailView)

1.导出效果图：

2.C#导出EXCEL通用类源代码：

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.IO;

using System.Text;

using System.Drawing;

///

///CommonClass 的摘要说明

///

public class CommonClass

{

public CommonClass()

{

//

//TODO: 在此处添加构造函数逻辑

//

}

public static void ReportToExcel(System.Web.UI.Control ctl, string fileName)

{

HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;

HttpContext.Current.Response.ContentType = "application/ms-excel";

HttpContext.Current.Response.Charset = "gb2312";

HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName + ".xls", Encoding.UTF8).ToString());

ClearChildControls(ctl);

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

ctl.RenderControl(htw);

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}

private static void RecursiveClear(Control control)

{

for (int i = control.Controls.Count - 1; i >= 0; i--)

{

RecursiveClear(control.Controls[i]);

}

if (control is Repeater)

{

control.Parent.Controls.Remove(control);

}

else if (control is LinkButton)

{

LiteralControl literal = new LiteralControl();

control.Parent.Controls.Add(literal);

literal.Text = ((LinkButton)control).Text;

control.Parent.Controls.Remove(control);

}

else if (control is Button)

{

control.Parent.Controls.Remove(control);

}

else if (control is System.Web.UI.WebControls.Image)

{

if (((System.Web.UI.WebControls.Image)control).Visible)

{

control.Parent.Controls.Add(new LiteralControl("o"));

}

control.Parent.Controls.Remove(control);

}

else if (control is ListControl)

{

LiteralControl literal = new LiteralControl();

control.Parent.Controls.Add(literal);

try

{

literal.Text = ((ListControl)control).SelectedItem.Text;

}

catch

{

}

control.Parent.Controls.Remove(control);

}

return;

}

protected static void ClearChildControls(Control dg1)

{

if (dg1 is GridView)

{

GridView dg = (GridView)dg1;

for (int i = dg.Columns.Count - 1; i >= 0; i--)

{

if (dg.Columns[i].GetType().Name == "ButtonColumn"

|| dg.Columns[i].GetType().Name == "CheckBoxField"

|| dg.Columns[i].GetType().Name == "CommandField")

{

dg.Columns[i].Visible = false;

}

}

RecursiveClear(dg1);

}

else

{

RecursiveClear(dg1);

}

}

}

3.调用方法：

CommonClass.ReportToExcel(GridView1, "从GridView导出的EXCEL");(责任编辑：51CSharp.net)

转载于:https://www.cnblogs.com/Sue_/articles/1663422.html