示例:Call ListviewToCSV(Listview1,"C:\123.csv")
最后一个参数Encabezado决定是是否导出表头。默认是导出的。
函数代码如下:
Public Function ListviewToCSV(ListView As ListView, sFile As String, Optional Encabezado As Boolean = True) As Boolean
On Error GoTo ContErr
If ListView.ListItems.Count = 0 Then Exit Function
Dim i As Long, j As Long
Open sFile For Output As #1
If Encabezado = True Then
For i = 1 To ListView.ColumnHeaders.Count
Print #1, ListView.ColumnHeaders(i).Text & ",";
Next i
Print #1,
End If
For i = 1 To ListView.ListItems.Count
Print #1, ListView.ListItems(i) & ",";
For j = 1 To ListView.ColumnHeaders.Count - 1
Print #1, ListView.ListItems(i).SubItems(j) & ",";
Next
Print #1,
Next i
Print #1,
ListviewToCSV = True
Close #1
Exit Function
ContErr:
MsgBox Err.Description
End Function
摘自:网络整理
相关文章参考:
※vb Listview扁平表头的列表框
★VB部分相关文章推荐:★