Библиотека CsvHelper – быстрый и простой в использовании способ чтения и записи пользовательских объектов в csv-файлы
Imports CsvHelper
Imports System.IO
...
Public Class MyDataClass
Public Property FieldA As Integer
Public Property FieldB As String
....
Public Property FieldX As String
End Class
...
' *** Пишем в CSV файл ***
Dim MyData1 = New MyDataClass With {.FieldA = 1, .FieldB = "2", .FieldX = "X"}
Using writer = New StreamWriter(Server.MapPath("~/AppData/Output.csv"))
Dim csv = New CsvWriter(writer)
csv.Configuration.Encoding = Encoding.UTF8
csv.WriteHeader(Of MyDataClass)()
csv.WriteRecord(MyData)
End Using
' *** Читаем из CSV файла ***
Using reader = New StreamReader(Server.MapPath("~/AppData/Output.csv"), True)
Dim csv = New CsvReader(reader)
csv.Configuration.IgnoreHeaderWhiteSpace = True
'csv.Configuration.Delimiter = ";"
'CSVReader will now read the whole file into an enumerable
Dim records As IEnumerable(Of MyDataClass) = csv.GetRecords(Of MyDataClass)().ToList()
'First 5 records in CSV file will be printed
'For Each record As DataRecord In records.Take(5)
For Each record In records.Take(3)
Response.Write(record.FieldA, record.FieldB, record.FieldX)
Next
End Using
Ссылки по теме: