How to add header using Filehelper with DataTableToCSV

Question

I am using:

DataTableToCSV(datatable,filepath)

to create a CSV file. Which is generating perfect CSV. Now how do I add column names when using DataTableToCSV?

score 1 · Answer 1 · answered Mar 06 '14 at 08:13

1

You can use the following:

[DelimitedRecord(","), IgnoreFirst(1)]
public class Person
{
    // Must specify FieldOrder too
    [FieldOrder(1), FieldTitle("Name")]
    string name;

    [FieldOrder(2), FieldTitle("Age")]
    int age;
}

...

var engine = new FileHelperEngine<Person>
{
    HeaderText = typeof(Person).GetCsvHeader()
};

...

engine.WriteFile(@"C:\people.csv", people);

reference to https://gist.github.com/1391429

answered Mar 06 '14 at 08:13

Adel

1,468
15
18

I have a filehelper.dll, where to add this gist ? – Rizwan Mumtaz Mar 06 '14 at 10:42
Please look into the following link: http://www.codeproject.com/Articles/12170/FileHelpers-v-Delimited-CSV-or-Fixed-Data-Impor – Adel Mar 06 '14 at 10:55

How to add header using Filehelper with DataTableToCSV

1 Answers1