导出数据从listview导出而不导出HTML标记 [英] Export Data to excel from listview without exporting HTML tags
本文介绍了导出数据从listview导出而不导出HTML标记的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须将listview中的数据导出到excel,我使用下面的代码,它将数据导出到excel但是除了html设计之外,如何在不导出HTML内容的情况下导出listview数据...
I have to export data from listview to excel, I am using below code, it exports data to excel but along with html design, how could I export listview data without exporting HTML content...
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=Result.xls");
Response.ContentType = "applicatio/excel";
StringWriter sw = new StringWriter(); ;
HtmlTextWriter htm = new HtmlTextWriter(sw);
ListView2.RenderControl(htm);
Response.Write(sw.ToString());
Response.End();
excel表中的数据表示如下......
Data in excel sheet is represented as below...
<tr>
<td> 118711 </td>
<td> 101 </td>
<td> TLALA,,KHALI </td>
<td> 43.00 </td>
<td> 43 </td>
<td> 43 </td>
<td> 43 </td>
<td> 43 </td>
<td> C </td>
<td> 1 </td>
</tr>
<tr>
<td> 118714 </td>
<td> 102 </td>
<td> LARA,,BROWN </td>
<td> 45.00 </td>
<td> 45 </td>
<td> 45 </td>
<td> 45 </td>
<td> 45 </td>
<td> C </td>
<td> 1 </td>
</tr>
<tr>
<td> 118717 </td>
<td> 103 </td>
<td> MARTIN,,FRASER </td>
<td> 23.00 </td>
<td> 23 </td>
<td> 23 </td>
<td> 23 </td>
<td> 23 </td>
<td> D </td>
<td> 0 </td>
</tr>
<tr>
<td> 118720 </td>
<td> 104 </td>
<td> WILLIAM,,BLACK </td>
<td> 56.00 </td>
<td> 56 </td>
<td> 56 </td>
<td> 56 </td>
<td> 56 </td>
<td> B </td>
<td> 2 </td>
</tr>
推荐答案
怎么会我只将listview的值存储到excel文件。
How would I store only values of listview to excel file.
这篇关于导出数据从listview导出而不导出HTML标记的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文