将Listview数据导出到Excel
问题描述：
您好，
如何将Listview的数据导出到excelsheet?
请帮助
-谢谢
Hello,
How can I export listview's data to excelsheet ?
Kindly help
- Thanks
答
您好，
您可以使用
创建一个excel对象
Dim _xCelObj = CreateObject("Excel.Application")
从那里可以提取将要使用的工作簿和工作表，然后循环到列表视图的列和行以写入工作表.
这里是您可以使用的链接. br/>
http://support.microsoft.com/default.aspx/kb/301982
http://www.eggheadcafe.com/tutorials/aspnet/b1991521-34d0-4d39-8d60- 73af32d0de43/net-listview-control-exp.aspx
希望能有所帮助.
Hi There,
You can create an excel object using
Dim _xCelObj = CreateObject("Excel.Application")
from there you can extract the workbook and sheet that you will be using
and Loop to your listview columns and rows to write to the sheet.
Here are links that you could use.
http://support.microsoft.com/default.aspx/kb/301982
http://www.eggheadcafe.com/tutorials/aspnet/b1991521-34d0-4d39-8d60-73af32d0de43/net-listview-control-exp.aspx
Hope that helps.