Grid export excel header

[IT]

Hi Guys,

 

I'm wondering if would be possible to add a title/header to excel exported file from grid.

Something similar to how the export to pdf shows a nice title on top of page.

Is there any way to accomplish this?

 

Cheers!

 

[Dimiter Madjarov]

Hello CORNEL,

You could use the excelExport event handler of the Grid and prepend a row in the exported Workbook. Here is an example of this.

Regards,
Dimiter Madjarov
Telerik

 

 

[IT]

Hi Dimiter,

 

Thank you for the prompt reply!

The solution looks intriguing. 

Any pointers how to go about expanding the cell across multiple columns and centering the content to look more like a proper title/header ?

 

Cheers!

[Dimiter Madjarov]

Hello CORNEL,

This could be achieved by further customizing the options of the inserted cell:

http://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.cells.colSpan

http://docs.telerik.com/kendo-ui/api/javascript/ooxml/workbook#configuration-sheets.rows.cells.textAlign

Regards,
Dimiter Madjarov
Telerik

 

 

[IT]

Hi Dimiter,

 

Thank you very much for the pointers!

It works flawlessly to create an excel report title.

 

Cheers!

[Dimiter Madjarov]

Hello CORNEL,

Thank you for the update. I am glad the issue is resolved.

Regards,
Dimiter Madjarov
Telerik

 

 

[InnovasiTeam]

Is there a way to do this for PDF exports, too?

[Alex Hajigeorgieva]

Hello Eric,

You can add a custom header to the PDF exported Kendo UI Grid with the help of  a template as shown in the overview section at:

http://docs.telerik.com/kendo-ui/controls/data-management/grid/pdf-export#page-template

Kind Regards,
Alex Hajigeorgieva
Telerik by Progress