将Listview数据导出到Excel [英] Export Listview data to 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.

这篇关于将Listview数据导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！