C#导出EXCEL没有网格线的解决方法介绍

isiqi

浏览: 16030408 次
性别:
来自: 济南

最近访客更多访客>>

nison

hellohank

wangyy

devcang

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-07 ( 335)
2012-06 ( 252)
2012-05 ( 362)
更多存档...

Excel C C++C#Office

做项目时，通过流导出数据到Excel却不显示网格线，真是郁闷。上网查了好久才得一良方（注意<XML>标签中的代码）：

DataTablethisTable=DBHelper.GetDataTable("select*fromtable");
stringsheetName="sheetName";
stringfileName="fileName";

if(thisTable!=null)
{
StringWritersw=newStringWriter();
sw.WriteLine("<htmlxmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
sw.WriteLine("<head>");
sw.WriteLine("");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<table>");
sw.WriteLine("<tr>");
sw.WriteLine("<td><strong>列名0</strong></td>");
sw.WriteLine("<td>列名1</td>");
sw.WriteLine("<td>列名2</td>");
sw.WriteLine("<td>列名3</td>");
sw.WriteLine("<td>列名4</td>");
sw.WriteLine("<td>列名5</td>");
sw.WriteLine("</tr>");
foreach(DataRowdrinthisTable.Rows)
{
sw.WriteLine("<tr>");
sw.WriteLine("<td>"+dr["C0"]+"</td>");
sw.WriteLine("<td>"+dr["C1"]+"</td>");
sw.WriteLine("<td>"+dr["C2"]+"</td>");
sw.WriteLine("<td>"+dr["C3"]+"</td>");
sw.WriteLine("<td>"+dr["C4"]+"</td>");
sw.WriteLine("<td>"+dr["C5"]+"</td>");
sw.WriteLine("</tr>");
}
sw.WriteLine("</table>");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
sw.Close();
Response.Clear();
Response.Buffer=true;
Response.Charset="UTF-8";
this.EnableViewState=false;
Response.AddHeader("Content-Disposition","attachment;filename="+fileName+".xls");
Response.ContentType="application/ms-excel";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}