从gridview中导入数据到EXCEL.docVIP

/// summary /// 到处查询结果到EXCEL表格 /// /summary /// param name=sender/param /// param name=e/param protected void btnExport_Click(object sender, EventArgs e) { GridViewExport.Visible = true; this.Response.ContentEncoding = System.Text.Encoding.GetEncoding(UTF-8); PrepareGridViewForExport(GridViewExport); string attachment = attachment; filename=LoanBillQuery.xls; Response.ClearContent(); Response.AddHeader(content-disposition, attachment); Response.ContentType = application/ms-excel; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); //导出前关闭分页 GridViewExport.AllowPaging = false; bind(); GridViewExport.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); GridViewExport.Visible = false; //到处后打开分页 GridViewExport.AllowPaging = true; bind(); } public override void VerifyRenderingInServerForm(Control control) { //Confirms that an HtmlForm control is rendered for the specified ASP.NET server control at run time //确认一个HtmlForm控件呈现为指定的ASP.NET服务器控件在运行时 //这个是帮助文档里面的英文，我是用谷歌翻译得出来的…… } /// summary /// 做好导出准备 /// /summary /// param name=gvgridview控件/param private void PrepareGridViewForExport(Control gv) { LinkButton lb = new LinkButton(); string name = String.Empty; Literal l = new Literal(); for (int i = 0; i gv.Controls.Count; i++) { if (gv.Controls[i].GetType() == typeof(LinkButton)) { l.Text = (gv.Controls[i] as LinkButton).Text; gv.Controls.Remove(gv.Controls[i]); gv.Controls.AddAt(i, l); } else if (gv.Controls[i].GetType() == typeof(DropDownList)) { l.Text = (gv.Controls[i] as DropDownList).SelectedItem.Text; g