|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 约定的童话 于 2021-2-28 09:41 编辑
Sub 提取log()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
t = Timer
On Error Resume Next
Dim i, n, arr, brr(1 To 1000, 1 To 8)
F = Dir(ThisWorkbook.Path & "\" & "*.log*")
Do While F <> ""
arr = Split(ReadXML(ThisWorkbook.Path & "\" & F), Chr(10))
For i = 1 To UBound(arr) Step 11
n = n + 1
brr(n, 1) = Split(F, "-P")(0)
brr(n, 2) = Left(arr(i), 8)
brr(n, 3) = Mid(arr(i), 40, 1) & Mid(arr(i), 43, 1) & Mid(arr(i), 46, 1) & Mid(arr(i), 49, 1)
brr(n, 4) = Mid(arr(i), 51, 2)
brr(n, 5) = Mid(arr(i), 55, 1) & Mid(arr(i), 58, 1) & Mid(arr(i), 61, 1)
brr(n, 6) = Mid(arr(i), 64, 1) & Mid(arr(i), 67, 1)
brr(n, 7) = Mid(arr(i), 70, 1) & Mid(arr(i), 73, 1) & Mid(arr(i), 76, 1)
Next
F = Dir
Loop
[A2].Resize(UBound(brr), 8) = brr
MsgBox "转换完毕!耗时:" & Format(Timer - t, "0.00") & "秒!", , "报告!"
End Sub
|
评分
-
1
查看全部评分
-
|