vb程序中如何读取文本文件指定行指定位置的数据?

来源:百度知道 编辑:UC知道 时间:2024/05/28 12:34:31
请高手指教!每行中数据是以tab键隔开的。

'这个代码有要求:每个数据不能大于8个字符(tab键默认的所占的字符长度)
Private Sub Form_Click() '请点击窗体
Me.Cls
Dim xRow, yLine, i, j As Long, Temp As String, Arr(1 To 99) As String
xRow = Val(InputBox("输入行数:"))
yLine = Val(InputBox("输入列数:"))
Me.AutoRedraw = True: j = 1
Open "C:\Documents and Settings\Administrator\桌面\1.txt" For Input As #1 '文件路径
For i = 1 To xRow
Input #1, Temp
Next i
Close #1
For i = 1 To Len(Temp)
If Mid(Temp, i, 1) = Chr(9) Then
Arr(j) = Left(Temp, i - 1): Temp = Replace(Temp, Arr(j) & Chr(9), "", , 1)
j = j + 1: i = 0
Else
If i = 9 Then
Arr(j) = Trim(Left(Temp, i - 1)): Temp = Replace(Temp, Arr(j), "", , 1)
j = j + 1: i = 0
End If
End If
If Len(Temp) = 0 Then Exit For
Next i
Print Arr(yLine)
End Sub

又或者用下面的代码,没有上面的要求了:

Private Sub Form_Click() '