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=myPagepage/param /// param name=dgdatagrid/param /// param name=namefilename/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=myPagepage/param /// param name=ctldatagrid/param /// param name=filenamefilename/param public void ExportToExcel(Page myPage,DataGrid ctl,string filename) { HttpResponse Response; Response=myPage.Response; bool CurrCtl