|
- Sub 导入TXT只要一行标题()
- Dim arr$$(), m&, Mypath$$, brr(1 To 65535, 1 To 43)
- Dim i, sr$$, temp, n&
- With Application.FileDialog(msoFileDialogFolderPicker)
- .InitialFileName = ThisWorkbook.Path & ""
- If .Show = False Then [A1].Activate: Exit Sub
- Mypath = .SelectedItems(1) & ""
- End With
- Call GetFiles(arr, m, Mypath)
- With Sheet1
- .UsedRange.ClearContents '清除原有的数据
- n = 0
- For i = 1 To UBound(arr)
- Open arr(i) For Input As #1 '使用open语句输入
- k = 0 '每个文件的行数
- Do While Not EOF(1) '运行到文件的结尾结束
- Line Input #1, sr '按行读取数据
- k = k + 1
- If i = 1 Or k > 1 Then '如果第1个文件或者其他文件第2行开始,则处理
- temp = Split(sr, ";")
- n = n + 1
- For j = 1 To UBound(temp) + 1
- brr(n, j) = temp(j - 1)
- Next
- End If
- Loop
- Close #1 '关闭文本文件
- Next
- .Range("a1").Resize(n, UBound(brr, 2)) = brr '将数组写入单元格
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|