Linux下java 调用vba,使用VBA将linux文本文件加载到excel中

I have a text file created on linux, if I open it in Word pad the file appears normally. However when I open it in notepad, and when I try to load it into excel using the code below it appears as a single line.

' Open the file

Open Filename For Input As #1

' Look for the Table Title

Do While Not (EOF(1) Or InStr(TextLine, TableTitle) > 0)

Line Input #1, TextLine

Loop

How can I split it into the original lines? Is there an end of line seperator, that vba can use?

解决方案

Linux uses a line-feed (\n) to denote a new line rather than the carriage return+line-feed (\r\n) as used by Windows so you can't use Line input, instead:

Open Filename For Input As #1

'//load all

buff = Input$(LOF(1), #1)

Close #1

'//*either* replace all lf -> crlf

buff = replace$(buff, vbLf, vbCrLf)

msgbox buff

'//*or* line by line

dim lines() As String: lines = split(buff, vbLf)

for i = 0 To UBound(lines)

msgbox lines(i)

next