CSVHelper FormatException与DateTime [英] CSVHelper FormatException with DateTime

问题描述

我遇到的问题尤其是CSVHelper库.

The issue I have is with the CSVHelper library in particular.

我的csv文件看起来像这样:

My csv file looks something like this:

Number,Date,Account,Amount,Subcategory,Memo
 ,09/05/2017,XXX XXXXXX,-29.00,FT , [Sample string]
 ,09/05/2017,XXX XXXXXX,-20.00,FT ,[Sample string]
 ,08/05/2017,XXX XXXXXX,-6.30,PAYMENT,[Sample string]

我使用CSVHelper所做的事情是这样的:

What I am doing with CSVHelper is this:

        List<Transaction> result = new List<Transaction>();
        using (TextReader fileReader = File.OpenText("data.csv"))
        {
            var csv = new CsvReader(fileReader);
            result = csv.GetRecords<Transaction>().ToList();
        }

问题在于，当它尝试在最后一行执行GetRecord时，出现此异常:

The issue is that when It tries to execute GetRecord on the last line, I get this exception:

Unhandled Exception: System.FormatException: String was not recognized as a valid DateTime.
   at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.DateTime.Parse(String s, IFormatProvider provider, DateTimeStyles styles)
   at CsvHelper.TypeConversion.DateTimeConverter.ConvertFromString(TypeConverterOptions options, String text)
   at lambda_method(Closure )
   at CsvHelper.CsvReader.CreateRecord[T]()
   at CsvHelper.CsvReader.<GetRecords>d__65`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

如您所见，数据存在一些问题-第一列为空或字符串为null.即便如此，异常消息仍指向日期(第二列)的问题.

As you can see the data has some issues - the first column is either empty or has the string null. Even then, the exception message points to a problem with the Date which is the second column.

任何帮助将不胜感激.

推荐答案

我的猜测是，您的默认区域性指定的日期格式与CSV文件中的日期格式不同.尝试将区域性设置为与数据相匹配的区域.

My guess is that your default culture specifies a different date format than what is in the CSV file. Try setting the culture to one that matches the data.

    var csv = new CsvReader(fileReader);
    csv.Configuration.CultureInfo = CultureInfo.GetCultureInfo("en-GB");
    result = csv.GetRecords<Transaction>().ToList();

提琴: https://dotnetfiddle.net/iTvc4Y

这篇关于CSVHelper FormatException与DateTime的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！