How do I create column headers using CsvHelper?

Question

So I just installed CsvHelper because that's the one I heard was the better one to use. I looked at the documentation and tried to figure out how to accompish what I wanted which is to create 1 column and fill it with values that are seperated with commas (,). And then a cell under that one that would have the corresponding value so like this

ID,Type,Name,Description,Image
11,Variation,MyCoolProduct,A super cool product, Image1 | Image2

I dont want different columns to the side I want to have 1 column with a string inside that is formated like that.

This is what I did, which didnt work because you cant even open the file because you get a SYLK format issue

var records = new List<Columns>
{
    new Columns {ID = 12, Type = "Variation", Description = "Simple product with different colors",
                 Images = "Image1 | Image 2", Price = 19.99d}
    };

using (StreamWriter sw = new StreamWriter("Testfile.csv"))
{
    var writer = new CsvWriter(sw);
    writer.WriteRecords(records);
}

UPDATE

I've mapped it like this now, how do i write it out to a textfile?

public sealed class MyClassMap : ClassMap<Columns>
    {
        public MyClassMap()
        {
            Map(m => m.ID);
        }
    }

jamesbascle · Accepted Answer · 2018-05-21 05:12:19Z

1

You should generally create a CsvClassMap class and map your class to the CSV format you need.

It's really simple and has a nice fluent interface. Just do something like:

   public class ColMap : CsvClassMap<Column>
   {
       public ColMap()
       {
           Map(m=>m.ID).Name("ID").Index(0);
           .
           .
           .
       }
    }

Some of the other options after the .Index call will allow you to further configure the format of each of your columns.

answered May 21, 2018 at 5:12

jamesbascle

1,0132 gold badges11 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Mark Denom Over a year ago

Is CsvClassMap something that comes with the library?

jamesbascle Over a year ago

It is indeed. You also need to put the CSVWriter in a using, something I didn't notice before.

jamesbascle Over a year ago

Ahh sorry, in the newer versions it's just called ClassMap, I forgot about that!

Mark Denom Over a year ago

Updated my question with th classmap, how do i write it out to a csv file as I explained with like 1 column being 1 long string with the values seperated by a , ?

jamesbascle Over a year ago

Sorry I don't understand. What you mean by 1 long column but also separated?

Collectives™ on Stack Overflow

How do I create column headers using CsvHelper?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related