Public Sub AddHeaders(arr, ListView1 As Object)
'读入二维数组第一行写入到表头
'示例 AddHeaders arr,UserForm1.listview1
Dim i&
ListView1.ColumnHeaders.Clear
For i = 1 To UBound(arr, 2)
ListView1.ColumnHeaders.Add , , arr(1, i)
Next
End Sub
Public Sub AddList(arr, ListView1 As Object)
'读入二维数组,将第二行开始每行依次写入到listview控件中
Dim i&, j&, k&, brr
With ListView1
.ListItems.Clear '清空列表
For i = 2 To UBound(arr, 1)
ListView1.ListItems.Add , , arr(i, 1)
For j = 1 To UBound(arr, 2) - 1
ListView1.ListItems(i - 1).SubItems(j) = arr(i, j + 1)
Next
Next
End With
End Sub
'示例 AddHeaders arr,UserForm1.listview1