由网友(最好的生活状态：一个人时，安静而丰盛；两个人时，温暖而踏实。)分享简介：我用 CsvHelper 读写CSV文件，它是伟大的，但我不知道怎么写只是选择的类型的字段。I use CsvHelper to read and write CSV files and it is great, yet I don't understand how to write only selected...

我用 CsvHelper 读写CSV文件，它是伟大的，但我不知道怎么写只是选择的类型的字段。

I use CsvHelper to read and write CSV files and it is great, yet I don't understand how to write only selected type fields.

假设我们有：

using CsvHelper.Configuration;

namespace Project
{
    public class DataView
    {
        [CsvField(Name = "N")]
        public string ElementId { get; private set; }

        [CsvField(Name = "Quantity")]
        public double ResultQuantity { get; private set; }

        public DataView(string id, double result)
        {
            ElementId = id;
            ResultQuantity = result;
        }
    }
}

和我们想排除数量 CsvField 日起，我们通过目前产生类似CSV文件：

and we wanted to exclude "Quantity" CsvField from resulting CSV file that we currently generate via something like:

using (var myStream = saveFileDialog1.OpenFile())
{
    using (var writer = new CsvWriter(new StreamWriter(myStream)))
    {
        writer.Configuration.Delimiter = 't';
        writer.WriteHeader(typeof(ResultView));
        _researchResults.ForEach(writer.WriteRecord);
    }
}

我能使用动态地从CSV排除类型的字段？

What could I use to dynamically exclude a type field from the CSV?

如果这是我们可以处理生成的文件有必要，但我不知道如何删除整个CSV柱 CsvHelper 。

If it is necessary we could process the resulting file, yet I do not know how to remove an entire CSV column with CsvHelper.

推荐答案

你可以这样做：

using (var myStream = saveFileDialog1.OpenFile())
{
    using (var writer = new CsvWriter(new StreamWriter(myStream)))
    {
        writer.Configuration.AttributeMapping(typeof(DataView)); // Creates the CSV property mapping
        writer.Configuration.Properties.RemoveAt(1); // Removes the property at the position 1
        writer.Configuration.Delimiter = "t";
        writer.WriteHeader(typeof(DataView));
        _researchResults.ForEach(writer.WriteRecord);
    }
}

我们正迫使创建的属性映射，然后修改它，动态地去除列。

We are forcing the creation of the attribute mapping and then modifying it, removing the column dynamically.