Export to Excel - How to dynamically set header text using LINQ?

Question

My below code is working well except for one slight issue. When I open the excel sheet, the column headers are pulling directly from the code below I.E.data.FleetNumber displays as FleetNumber for the column header. Is it possible to overwrite this? E.G I want it to display Fleet No.

I've done a lot of searching but I cant find an answer. Any help is appreciated.

    public void ExportToBeDoneVehiclesToExcel()
    {
        int count = 10;

        var grid = new System.Web.UI.WebControls.GridView();

        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);

        var list = vehicleBusinessLogic.GetToBeDoneVehicles(count);
        grid.DataSource = from data in list
                            select new
                            {
                                data.RegistrationID,
                                data.FleetNumber,
                                data.VIN,
                                data.LocationDescription,
                                data.ServiceDescription,
                                data.NextInspectionDueDate
                            };
        grid.DataBind();

        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=Exported_ToBeDoneVehicles.xls");
        Response.ContentType = "application/excel";

        grid.RenderControl(htw);

        Response.Write(sw.ToString());
        Response.End();
    }

What type is list

Modar Na
– Modar Na

2017-03-28 15:33:20 +00:00
Commented Mar 28, 2017 at 15:33 — Modar Na
– Modar Na, Commented Mar 28, 2017 at 15:33

Modar Na · Accepted Answer · 2017-03-27 16:31:08Z

2

i can't test this but it seems logical to me

try specifying the variables names in the list

grid.DataSource = from data in list
                        select new
                        {
                            Reg = data.RegistrationID,
                            FleetNumber = data.FleetNumber,
                            VIN = data.VIN,
                            LocationDescription = data.LocationDescription,
                            ServiceDescription = data.ServiceDescription,
                            NextInspectionDueDate = data.NextInspectionDueDate
                        };

answered Mar 27, 2017 at 16:31

Modar Na

9287 silver badges18 bronze badges

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

2 Comments

MadDev Over a year ago

Yes that does work for displaying as Reg but it's not exactly what I'm looking for. Your suggestion does not work if I want to have spaces E.G Fleet No. Sorry I should have given FleetNumber as the example originally. I have edited my question. Thank you for your help!

Modar Na Over a year ago

Check comments is this what you looking for .. if yes then check this too

Collectives™ on Stack Overflow

Export to Excel - How to dynamically set header text using LINQ?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related