- protected void btn_out_Click(object sender, EventArgs e)
- {
- Response.ClearContent();
- Response.AddHeader("content-disposition", "attachment; filename=DATASHOW.xls");
- Response.ContentType = "application/excel";
- Response.Write(GetGridTableHtml(gv_show));
- 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();
-
- if (html.Contains("box-grid-static-checkbox"))
- {
- if (html.Contains("box-grid-static-checkbox-uncheck"))
- {
- html = "×";
- }
- else
- {
- html = "√";
- }
- }
-
-
- if (html.Contains("<img"))
- {
- string prefix = Request.Url.AbsoluteUri.Replace(Request.Url.AbsolutePath, "");
- html = html.Replace("src=\"", "src=\"" + prefix);
- }
-
- sb.AppendFormat("<td>{0}</td>", html);
- }
- sb.Append("</tr>");
- }
-
- sb.Append("</table>");
-
- return sb.ToString();
- }
~
|
