[vb.net] CSV파일 읽기

TextFieldParser

• CSV나 TSV를 다루기 위한 클래스다.

Dim objIoTFP As New Microsoft.VisualBasic.FileIO.TextFieldParser(strFilePath, Encoding.GetEncoding("Shift_JIS"))
読み込み時の設定
objIoTFP
区切り文字をカンマに設定
.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited
.SetDelimiters(",")
空白があった場合にTrimしない
.TrimWhiteSpace = False

 

CSV読み込み実行
While Not objIoTFP.EndOfData
    Dim arrayRow As String() = objIoTFP.ReadFields()
    Dim strVeiwResult As String = Nothing
    For Each objField As String In arrayRow
        表示
        strVeiwResult = strVeiwResult & objField & ","
      Next