Add a Header Row To Excel File through File Helpers

Question

I am following this example but I don't know how to make a header row in the final outputed excel file.

Your link is to the main FileHelpers page.

shamp00
– shamp00

2012-03-21 09:45:08 +00:00
Commented Mar 21, 2012 at 9:45 — shamp00
– shamp00, Commented Mar 21, 2012 at 9:45

shamp00 · Accepted Answer · 2012-03-21 10:33:23Z

1

You have to provide a 'template' Excel file with just the headers.

// Class record
[DelimitedRecord("|")]
public class MyClass
{
    public string Field1 { get; set; }
    public int Field2 { get; set; }
    public string Field3 { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        // create some data to export
        MyClass[] rows = new MyClass[2] { 
          new MyClass() { Field1 = "Apples",  Field2 = 23, Field3 = "Yes" },
          new MyClass() { Field1 = "Oranges", Field2 = 17, Field3 = "No"} 
        };

        ExcelStorage provider = new ExcelStorage(typeof(MyClass));
        // Set the destination Excel spreadsheet
        provider.FileName = @"MyClass.xlsx";

        // Template.xlsx contains just the column headers on row 1
        provider.TemplateFile = @"Template.xlsx"; 
        // StartRow is after the header row
        provider.StartRow = 2; 

        provider.OverrideFile = true;
        provider.InsertRecords(rows);
    }
}

answered Mar 21, 2012 at 10:33

shamp00

11.4k4 gold badges42 silver badges83 bronze badges

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

2 Comments

chobo2 Over a year ago

So I have to have another excel file with just the headers in it? It can't figure out based on the fields?

shamp00 Over a year ago

That's correct. The current (2.9.9) implementation of ExcelStorage.InsertRecords() does not generate any headers.

Collectives™ on Stack Overflow

Add a Header Row To Excel File through File Helpers

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related