For i = 0 To 14
zz = arr(i)
arr1 = Split(zz, Chr(34))
arr2 = Split(zz1, Chr(34))
For j = 1 To UBound(arr1) Step 2
Cells(i + kaishihang, Int((j + 1) / 2)) = arr1(j)
Next j
Next i
'上面一段整体替换掉:
For i = 0 To 14
arr1 = Split(arr(i), Chr(34)): n = 0
For j = 1 To UBound(arr1)
If InStr(arr1(j), ",") = 0 Then
n = n + 1
Cells(i + kaishihang, n) = arr1(j)
Else
If InStr(2, arr1(j), ",") = 0 Then
If i = 0 Then
Cells(1, n + 1) = Replace(Replace(arr1(j), ",", vbNullString), ":", vbNullString)
End If
Else
arr2 = Split(arr1(j), ",")
For k = 2 To UBound(arr2)
t = Split(arr2(k), ":")
If Len(t(1)) Then
n = n + 1
If i = 0 Then Cells(1, n) = Replace(Replace(t(0), ",", vbNullString), ":", vbNullString)
Cells(i + kaishihang, n) = t(1)
Else
If i = 0 Then Cells(1, n + 1) = Replace(Replace(t(0), ",", vbNullString), ":", vbNullString)
End If
Next
End If
End If
Next
Next |