C#中导出excel文档

private HttpContext Context = HttpContext.Current;

//数据导出
public string ExportData()
{

    Context.Response.ContentType = "application/vnd.ms-excel";    Context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");    Context.Response.Charset = "UTF-8";    string fileName = "成绩明细表.xls";//导出的excel文档名称    if (Context.Request.ServerVariables["http_user_agent"].ToString().IndexOf("Firefox") != -1){        Context.Response.AppendHeader("Content-Disposition",                    "attachment;filename=" + fileName);    }else    {        Context.Response.AppendHeader("Content-Disposition",                  "attachment;filename=" + Context.Server.UrlEncode(fileName));    }    #region 产生DataGrid，并让浏览器当做EXCEL下载或者打开    System.IO.StringWriter strWriter = new System.IO.StringWriter();    System.Web.UI.HtmlTextWriter htmlWriter = new         System.Web.UI.HtmlTextWriter(strWriter);    DataGrid dgExport = new DataGrid();    dgExport.DataSource = ds.Tables[0];//ds数据源    dgExport.AllowPaging = false;    dgExport.ItemStyle.Wrap = true;    dgExport.HeaderStyle.Wrap = true;    dgExport.AutoGenerateColumns = false;    this.AddDataBindColumns(dgExport);//exccel文档表头绑定    dgExport.ItemDataBound += new    DataGridItemEventHandler(dgExport_ItemDataBound);//excel单元格数据处理    dgExport.DataBind();    dgExport.RenderControl(htmlWriter);    Context.Response.Clear();    Context.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>" + strWriter.ToString());    Context.Response.End();

}

private void AddDataBindColumns(DataGrid dgExport)
{

dgExport.Columns.Add(new BoundColumn() { DataField = "name", HeaderText = "学号" });dgExport.Columns.Add(new BoundColumn() { DataField = "id", HeaderText = "身份证号" });dgExport.Columns.Add(new BoundColumn() { DataField = "grade", HeaderText = "成绩" });foreach (BoundColumn column in dgExport.Columns){    column.ItemStyle.HorizontalAlign = HorizontalAlign.Center;    column.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;    column.HeaderStyle.Width = 200;}

}

//格式化单元格
void dgExport_ItemDataBound(object sender, DataGridItemEventArgs e)
{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem){    DataRowView drv = (DataRowView)e.Item.DataItem;    e.Item.Cells[0].Text = "=\"" + drv["id"].ToString() + "\"";//对单元格数据进行单独处理}

}

/页面处理/

<span><iframe id="frmExport" style="display: none"></iframe> <a href="#" onclick="ExportData()">导出</a></span>

/js处理/

$("#frmExport").attr("src", “后台访问路径”);