datagrid 导出 excel;AJAX的页面的…

ASP.NET GridView导出Excel

最新推荐文章于 2025-09-11 21:09:27 发布

最新推荐文章于 2025-09-11 21:09:27 发布 · 106 阅读

文章标签：

#ui #c#

本文介绍如何在ASP.NET应用中实现GridView控件的数据导出到Excel文件，并解决了中文乱码的问题。通过设置页面属性、按钮触发器及响应头等步骤，确保数据正确输出。

public override void VerifyRenderingInServerForm(Control control) { //base.VerifyRenderingInServerForm (control); }

public static void ExportToExcelForDataGrid(DataGrid dg,string aDate,string aFileName) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Buffer= true; HttpContext.Current.Response.Charset="GB2312"; HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename="+ HttpUtility.UrlPathEncode(aFileName) +".xls"); HttpContext.Current.Response.ContentEncoding=System.Text.Encoding.GetEncoding("UTF-7"); HttpContext.Current.Response.ContentType = "application/ms-excel"; StringWriter oStringWriter = new System.IO.StringWriter(); HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); dg.RenderControl(oHtmlTextWriter); HttpContext.Current.Response.Write(oStringWriter.ToString()); HttpContext.Current.Response.End(); }

使用了AJAX的页面的GridView导出Excel，以及中文乱码问题解决

2011-01-24 21:03:01|分类： .Net |标签： |字号大中小订阅

1.首先在需要导出Excel的页面的<%@ Page Title="" Language="C#" MasterPageFile="~Master.Master" CodeBehind="List.aspx.cs" Inherits="List" enableEventValidation ="false"%>中加入enableEventValidation ="false"，这个很重要。

2.在UpdatePannel中加入按钮的触发器

</ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="export_excel" />//这里的ID指的是你单击导出Execel的控件，使这个控件回发。 </Triggers> </asp:UpdatePanel> 3.在按钮单击事件中写如下函数

protected void LinkButton2_Click(object sender, EventArgs e) { GridView1.AllowPaging = false; string strStyle = "<style>td{mso-number-format:"\\@";}</style>"; Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls "); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.ContentType = "application/ms-excel "; StringWriter oStringWriter = new StringWriter(); HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter); this.GridView1.RenderControl(oHtmlTextWriter); Response.Write(strStyle); Response.Write(oStringWriter.ToString()); //ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "alert", "Response.Write(oStringWriter.ToString())", true); Response.Flush(); Response.End(); GridView1.AllowPaging = true; }

问题：字符编码？用哪个？UTF-8、UTF-7、GB2312

如果表中有中文，则推荐使用GB2312，Web.config中配置全球化:

如果表中数字是以0开始的形如：08125...的话，使用string strStyle = "<style>td{mso-number-format:"\\@";}</style>";然后Response.Write(strStyle); 如上面代码中所示。

4.同样的在后台代码中写如下代码，这行代码是要确认运行时指定的服务器控件呈现，一定要添加
 public override void VerifyRenderingInServerForm(Control control) { }

==============合计

#region qzf2011-12-29 自动创建列绑定datagrid 的合计
public static void DataGridItemDataBoundCalcSumForAutoColumn(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e,ArrayList alSum) { if (e.Item.ItemType == ListItemType.Header) { for (int i = 0 ;i <e.Item.Cells.Count;i++) { alSum.Add(0M); } } else if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { for (int i = 0 ;i <e.Item.Cells.Count;i++) { Decimal dbl = 0M; try { dbl = Decimal.Parse(e.Item.Cells[i].Text.Trim()); } catch { } alSum[i] = Convert.ToDecimal(alSum[i]) + dbl; } } else if(e.Item.ItemType == ListItemType.Footer ) { for (int i = 0 ;i <e.Item.Cells.Count;i++) { try { if (Convert.ToDecimal(alSum[i])==0) continue; e.Item.Cells[i].Text = alSum[i].ToString(); } catch { } } } } #endregion } }