ExtAspNet根据Grid导出Excel

来源:互联网 发布:大庆电视台网络直播 编辑:程序博客网 时间:2024/06/02 06:31
 protected void Button1_Click(object sender, EventArgs e)    {        Response.ClearContent();        Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");        Response.ContentType = "application/excel";        Response.Write(GetGridTableHtml(Grid1));        Response.End();    }    private string GetGridTableHtml(Grid grid)    {        StringBuilder sb = new StringBuilder();        sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");        sb.Append("<tr>");        foreach (GridColumn column in grid.Columns)        {            sb.AppendFormat("<td>{0}</td>", column.HeaderText);        }        sb.Append("</tr>");        foreach (GridRow row in grid.Rows)        {            sb.Append("<tr>");            foreach (object value in row.Values)            {                string html = value.ToString();                sb.AppendFormat("<td>{0}</td>", html);            }            sb.Append("</tr>");        }        sb.Append("</table>");        return sb.ToString();    }

0 0
原创粉丝点击