Asp.net导出Excel报表（解决无网格问题）

最新推荐文章于 2017-08-12 16:45:57 发布

weixin_30642869

最新推荐文章于 2017-08-12 16:45:57 发布

阅读量112

点赞数

文章标签： ui

原文链接：http://www.cnblogs.com/AlexCheng/archive/2010/08/26/1809106.html

版权

随着单位活动的增多，各大4S店要求查看活动报名的要求的出现，导出Excel或者是Word文档功能显得尤为重要。可以大量节省编辑的工作时间和工作强度。
        今天花了点时间编写了各大报名品牌的Excel导出功能。原理非常简单，其实就想往页面输出报名列表，不同的是在输出HTML文本时在HEAD标记 HTML标记增加点东西。
       代码如下：

1 string strExportFileName = new SysCar.BLL.BrandCategory().GetModel(Convert.ToInt32( this .rblJoinBrand.SelectedValue)).Name;
2                  int actID = Convert.ToInt32(Request.QueryString[ " actid " ]);
3                 SysCar.BLL.Apply apply = new BLL.Apply();
4
5                 List < SysCar.Model.Apply > appExcel = apply.DataTableToList(apply.GetList( " (ActivityID= " + actID + " and PATINDEX('%| " + this .rblJoinBrand.SelectedValue + " |%',BrandCollection)>0) " ).Tables[ 0 ]);
6
7                 Response.ContentType = " application/vnd.ms-excel " ;
8                 Response.AddHeader( " Content-Disposition " , " inline;filename= "
9                      + HttpUtility.UrlEncode(strExportFileName + " _名单.xls " , Encoding.UTF8));
10
11
12                  // 如果输出为Word，修改为以下代码
13                  // Response.ContentType = "application/ms-word"
14                  // Response.AddHeader("Content-Disposition", "inline;filename=test.doc")
15
16                 StringBuilder sb = new StringBuilder();
17                 System.IO.StringWriter sw = new System.IO.StringWriter(sb);
18                 System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
19                 sb.Append( " <html xmlns:x=urn:schemas-microsoft-com:office:excel><head><meta http-equiv=Content-Type content=\ " text / html; charset = utf - 8 \ " > " );
20                 sb.Append( " <table><tr><td colspan=4> " + strExportFileName + " <font color='red'> " + appExcel.Count + " （人）</font></td></tr><tr><td>编号</td><td>姓名</td><td>性别</td><td>联系电话</td></tr> " );
21                  for ( int i = 0 ; i < appExcel.Count; i ++ )
22                 {
23                      string strSex = " 男 " ;
24                      if (Convert.ToInt32(appExcel[i].Sex) == 2 )
25                     {
26                         strSex = " 女 " ;
27                     }
28                     sb.Append( " <tr><td> " + appExcel[i].ApplyID + " </td><td> " + appExcel[i].Name + " </td><td> " + strSex + " </td><td> " + appExcel[i].Mobile + " </td></tr> " );
29
30                 }
31                 sb.Append( " </table> " );
32                 sb.Append( " </body></html> " );
33
34
35                 Response.Write(sb.ToString());
36                 Response.End();

关键点：

1
2 
3 < html xmlns:x = urn:schemas - microsoft - com:office:excel >
4 < head >
5 
17
18
19
20 
21 < meta http - equiv = Content - Type content = \ " text/html; charset=utf-8\ " >
22

转载于:https://www.cnblogs.com/AlexCheng/archive/2010/08/26/1809106.html