写入带有大写标题的 CSV 文件

发布于 2025-01-20 15:48:39 字数 600 浏览 2 评论 0原文

我正在尝试编写一个带有大写标题的 csv 文件。条目是对象的集合。

using (var streamWriter = new StreamWriter(csvStream))
            {
                var csvConfig = new CsvConfiguration(CultureInfo.CurrentCulture)
                {
                    PrepareHeaderForMatch = args => args.Header.ToUpper()
                };
                using (var csvWriter = new CsvWriter(streamWriter, csvConfig))
                {
                    csvWriter.WriteRecords<T>(entries);
                    streamWriter.Flush();
                }
           }

我可以看到文件已写入，但标题不是大写字母。这里有什么问题吗？

原文

I am trying to write a csv file but with upper case headers.
Entries is a collection of objects.

using (var streamWriter = new StreamWriter(csvStream))
            {
                var csvConfig = new CsvConfiguration(CultureInfo.CurrentCulture)
                {
                    PrepareHeaderForMatch = args => args.Header.ToUpper()
                };
                using (var csvWriter = new CsvWriter(streamWriter, csvConfig))
                {
                    csvWriter.WriteRecords<T>(entries);
                    streamWriter.Flush();
                }
           }

I can see the file has been written but headers are not in capital letter. What is wrong here?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

春风十里 2025-01-27 15:48:39

PrepareHeaderForMatch 用于在您想要读取而不是写入的 csv 文件时将标头匹配并将其映射到模型。要写入 csv 文件，您需要为属性设置 Name 属性，如下所示：

  public class CsvModel
    {
        [Name("NAME")]
        public string Name { get; set; }

        [Name("FAMILY")]
        public string Family { get; set; }
    }

或者您可以在 csv 映射中设置标头名称：

public class CsvModelMap : ClassMap<CsvModel>
{
    public CsvModelMap()
    {
        Map(m => m.Name).Index(0).Name("NAME");
        Map(m => m.Family).Index(1).Name("FAMILY");
    }
}

PrepareHeaderForMatch is for matching and mapping headers to your model when you want to Read a csv file not writing. for writing to csv file, you need to set Name attribute for your properties like this:

  public class CsvModel
    {
        [Name("NAME")]
        public string Name { get; set; }

        [Name("FAMILY")]
        public string Family { get; set; }
    }

Or you can set header names in csv mapping:

public class CsvModelMap : ClassMap<CsvModel>
{
    public CsvModelMap()
    {
        Map(m => m.Name).Index(0).Name("NAME");
        Map(m => m.Family).Index(1).Name("FAMILY");
    }
}

回复收藏 0 原文

九公里浅绿 2025-01-27 15:48:39

如果您想要一种更通用的方法来制作所有标题大写，则可以使用map（键入ClasStype，MemberInfo Member，bool useexistingmap = true）。

void Main()
{
    var records = new List<CsvModel>
    {
        new CsvModel { Name = "name", Family = "first" },
    };

    using (var csv = new CsvWriter(Console.Out, CultureInfo.InvariantCulture))
    {
        var fooMap = new DefaultClassMap<CsvModel>();

        var properties = typeof(CsvModel).GetProperties();
        foreach (var property in properties)
        {
            fooMap.Map(typeof(CsvModel), property).Name(property.Name.ToUpper());
        }
        
        csv.Context.RegisterClassMap(fooMap);
        
        csv.WriteRecords(records);
    }
}

public class CsvModel
{
    public string Name { get; set; }
    public string Family { get; set; }
}

If you want a more generic approach to making all the headers uppercase, you can use the Map(Type classType, MemberInfo member, bool useExistingMap = true) overload of the Map method.

void Main()
{
    var records = new List<CsvModel>
    {
        new CsvModel { Name = "name", Family = "first" },
    };

    using (var csv = new CsvWriter(Console.Out, CultureInfo.InvariantCulture))
    {
        var fooMap = new DefaultClassMap<CsvModel>();

        var properties = typeof(CsvModel).GetProperties();
        foreach (var property in properties)
        {
            fooMap.Map(typeof(CsvModel), property).Name(property.Name.ToUpper());
        }
        
        csv.Context.RegisterClassMap(fooMap);
        
        csv.WriteRecords(records);
    }
}

public class CsvModel
{
    public string Name { get; set; }
    public string Family { get; set; }
}

回复收藏 0 原文

~没有更多了~