DataGrid导出EXCEL的几个方法(WebControl).doc

DataGridμ?3?EXCELμ?????·?·¨(WebControl).txtD?ê±oò??μ????×2??òμ￥￡?oóà′??μ?×??o2??òμ￥￡??ùoóà′??μ?×??oo￠×ó2??òμ￥?￡??ê????aμà×??oê?2?ê?íü??μ?ê±oò￡?·′????μ?????3t?￡DataGirdμ?3?EXCELμ?????·?·¨￡¨WebControl￡? using System; using System.Data; using System.Text; using System.Web; using System.Web.UI; using System.Diagnostics; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.Collections; namespace bookstore { /// <summary> /// myExcel μ??aòa?μ?÷?￡ /// </summary> public class myExcel { public myExcel() { } /// <summary> /// ??DATAGRIDμ?3??aEXCEL???t·?·¨ò?, /// 2?êyê?:òaμ?3?μ?DATAGRIDμ?IDoíòa±￡′???à′μ?EXCEL???t?? /// </summary> /// <param name="myPage">page</param> /// <param name="dg">datagrid</param> /// <param name="name">filename</param> private void OutExcel(Page myPage,DataGrid dg,string name) { HttpResponse Response; Response=myPage.Response; string name1="attachment;filename="+name+".xls"; dg.Visible=true; Response.Clear(); Response.Buffer= true; Response.Charset="GB2312"; Response.AppendHeader("Content-Disposition",name1); Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType ="application/ms-excel"; dg.EnableViewState = false; System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); dg.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } /// <summary> /// ??DATAGRIDμ?3??aEXCEL???t·?·¨?t, /// 2?êyê?:òaμ?3?μ?DATAGRIDμ?IDoíòa±￡′???à′μ?EXCEL???t?? /// </summary> /// <param name="myPage">page</param> /// <param name="ctl">datagrid</param> /// <param name="filename">filename</param> public void ExportToExcel(Page myPage,DataGrid ctl,string filename) { HttpRespon