CSV助手写空字符串而不是默认的DateTime

Question

嗨，我在使用CSVHELPER上在CSV文件上编写默认DateTime列时面临问题 我在做的是

  using (var memoryStream = new MemoryStream())
            {
                using (var streamWriter = new StreamWriter(memoryStream))
                {
                    using (var csvWriter = new CsvWriter(streamWriter, CultureInfo.InvariantCulture))
                    {
                        if (!string.IsNullOrEmpty(header))
                        {
                            csvWriter.WriteField(header);
                            csvWriter.NextRecord();
                        }
                        csvWriter.Configuration.TypeConverterOptionsCache.GetOptions<DateTime>().Formats = new[] { "dd/MM/yyyy" };
                        csvWriter.Configuration.TypeConverterOptionsCache.GetOptions<DateTime?>().Formats = new[] { "" };
                        csvWriter.Configuration.RegisterClassMap<TMap>();
                        csvWriter.WriteRecords(records);
                        WriteGrandTotals(columnTotals, csvWriter);
                    }
                }

                return memoryStream.ToArray();
            }

结果

我在DB中有默认的日期时间 而不是这个误导数据

Answer 1

您不需要此处的类型转换。您需要的行为已经存在：

using System.Collections;
using System.Globalization;
using CsvHelper;
using CsvHelper.Configuration.Attributes;

var records = new List<TMap>
{
    new TMap { Id = 1, Stamp = DateTime.Now, Filer = "X"},
    new TMap { Id = 2, Stamp = null, Filer = "X" },
    new TMap { Id = 3, Stamp = DateTime.Now, Filer = "X" },
};

using (var writer = new StreamWriter("file.csv"))
{
    using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture))
    {
        csv.WriteRecords((IEnumerable)records);
    }
}

class TMap
{
    public int Id { get; set; }

    [Format("dd/MM/yyyy")]
    public DateTime? Stamp { get; set; }
    
    public string Filer { get; set; }
}

结果：

Id,Stamp,Filer
1,06/06/2022,X
2,,X
3,06/06/2022,X