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

最新推荐文章于 2017-04-17 16:19:00 发布

weixin_34008805

最新推荐文章于 2017-04-17 16:19:00 发布

阅读量232

点赞数

文章标签： c#

原文链接：http://www.cnblogs.com/linyechengwei/archive/2009/11/07/1597835.html

版权

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

DataTable thisTable = DBHelper.GetDataTable( " select * from table " );
string sheetName = " sheetName " ;
string fileName = " fileName " ;

if (thisTable != null )
{
    StringWriter sw = new StringWriter();
    sw.WriteLine( " <html xmlns: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 (DataRow dr in thisTable.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();
}

转载于:https://www.cnblogs.com/linyechengwei/archive/2009/11/07/1597835.html

weixin_34008805

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
C#导出EXCEL没有网格线的解决方法

今天在做项目时，通过流导出数据到Excel却不显示网格线，真是郁闷。上网查了好久才得一良方（注意<XML>标签中的代码）：DataTablethisTable=DBHelper.GetDataTable("select*fromtable");stringsheetName="sheetName";stringfileName="fileName";if(...
复制链接

扫一扫