Nukepayload2.Csv 1.1.0

Sample Code

Convert Csv string to .NET Object

Goal: convert the following csv string to .NET Object.

Id,Rate,Name,Date,IsUsed
-233,12345.12,test string,2018-05-09,True
0,-12345.12,,2018-09-09,False

1. Create a model class

VB

Public Class MyCsvModel
    Public Property Id As Integer
    Public Property Rate As Double
    Public Property Name As String
    Public Property [Date] As Date
    Public Property IsUsed As Boolean
End Class

C#

public class MyCsvModel
{
    public int Id { get; set; }
    public double Rate { get; set; }
    public string Name { get; set; }
    public DateTime Date { get; set; }
    public bool IsUsed { get; set; }
}

2. Convert csv to IReadOnlyList of MyCsvModel

Assume that csv is a System.String that contains csv.

VB

Dim converted = CsvConvert.DeserializeObject(Of MyCsvModel)(csv)

C#

var converted = CsvConvert.DeserializeObject<MyCsvModel>(csv);

Convert .NET Object back to Csv string

VB

csv = CsvConvert.SerializeObject(converted)

C#

csv = CsvConvert.SerializeObject(converted);

Trouble shooting

If these sample codes throw FormatException when deserializing, please set the current culture of the current thread to "zh-CN". Because I'm using Chinese date time format when writing this sample.