C#导出EXCEL没有网格线的解决方法代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 C#导出EXCEL没有网格线的解决方法
作者:Dezai.CN / 发布于2012/3/20/ 642
今天在做项目时，通过流导出数据到Excel却不显示网格线，真是郁闷。上网查了好久才得一良方（注意标签中的代码）：
<div><span style="color: rgb(0, 0, 0);">DataTable thisTable </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> DBHelper.GetDataTable(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">select * from table</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
</span><span style="color: rgb(0, 0, 255);">string</span><span style="color: rgb(0, 0, 0);"> sheetName </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">sheetName</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">;
</span><span style="color: rgb(0, 0, 255);">string</span><span style="color: rgb(0, 0, 0);"> fileName </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">fileName</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">;

</span><span style="color: rgb(0, 0, 255);">if</span><span style="color: rgb(0, 0, 0);"> (thisTable </span><span style="color: rgb(0, 0, 0);">!=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 255);">null</span><span style="color: rgb(0, 0, 0);">)
{
StringWriter sw </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 255);">new</span><span style="color: rgb(0, 0, 0);"> StringWriter();
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><html xmlns:x=\</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">urn:schemas</span><span style="color: rgb(0, 0, 0);">-</span><span style="color: rgb(0, 0, 0);">microsoft</span><span style="color: rgb(0, 0, 0);">-</span><span style="color: rgb(0, 0, 0);">com:office:excel\</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><head></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><!--[if gte mso 9]></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><xml></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"> <x:ExcelWorkbook></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <x:ExcelWorksheets></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">   <x:ExcelWorksheet></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">    <x:Name></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> sheetName </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></x:Name></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">    <x:WorksheetOptions></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">      <x:Print></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">       <x:ValidPrinterInfo /></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">      </x:Print></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">    </x:WorksheetOptions></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">   </x:ExcelWorksheet></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  </x:ExcelWorksheets></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></x:ExcelWorkbook></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></xml></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><![endif]--></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></head></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><body></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"><table></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"> <tr></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td><strong>列名0</strong></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td>列名1</td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td>列名2</td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td>列名3</td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td>列名4</td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td>列名5</td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"> </tr></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
</span><span style="color: rgb(0, 0, 255);">foreach</span><span style="color: rgb(0, 0, 0);"> (DataRow dr </span><span style="color: rgb(0, 0, 255);">in</span><span style="color: rgb(0, 0, 0);"> thisTable.Rows)
{
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"> <tr></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C0</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C1</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C2</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C3</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C4</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">  <td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> dr[</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">C5</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">] </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></td></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"> </tr></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
}
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></table></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></body></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.WriteLine(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);"></html></span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
sw.Close();
Response.Clear();
Response.Buffer </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 255);">true</span><span style="color: rgb(0, 0, 0);">;
Response.Charset </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">UTF-8</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">;
</span><span style="color: rgb(0, 0, 255);">this</span><span style="color: rgb(0, 0, 0);">.EnableViewState </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 255);">false</span><span style="color: rgb(0, 0, 0);">;
Response.AddHeader(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">Content-Disposition</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">, </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">attachment; filename=</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(0, 0, 0);"> fileName </span><span style="color: rgb(0, 0, 0);">+</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">.xls</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
Response.ContentType </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> </span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">application/ms-excel</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">;
Response.ContentEncoding </span><span style="color: rgb(0, 0, 0);">=</span><span style="color: rgb(0, 0, 0);"> System.Text.Encoding.GetEncoding(</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(128, 0, 0);">GB2312</span><span style="color: rgb(128, 0, 0);">"</span><span style="color: rgb(0, 0, 0);">);
Response.Write(sw);
Response.End();
}</span></div>
试试其它关键字
　C#导出EXCEL没有网格线的解决方法　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)