将 GridView 导出 为 excel

public void ExportToExcel(string FileType, string FileName, GridView dv) { try { //dv.PageSize = 100; //bindData(); dv.BottomPagerRow.Visible = false; dv.BorderWidth = 1; dv.CellPadding = 1; dv.CellSpacing = 0; dv.Columns[0].Visible = false; dv.Columns[dv.Columns.Count - 1].Visible = false; dv.Width = 661; Response.Charset = "GB2312"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); dv.RenderControl(hw); Response.Write(tw.ToString()); Response.End(); } catch (Exception ex) { } }

调用方式 ExportToExcel("application/ms-excel", "申请督察.xls", this.GridView1);