Excel Export - Worksheet Header

[Cheryl Barber]

I saw an example online of how to convert the first few rows of a worksheet into a "header" section when exporting a grid to excel. However, is there a way to create an actual header in excel when exporting that will display on every page when printed? I attached some pictures for examples. 

Attachment: Examples_fd6acd65.zip

[Balaji Sekar]

Hi Cheryl, 

 

Thanks for contacting the Syncfusion support. 

 

By default we can bind the rows in top of excel sheet using header section it will render the headers on the excel sheet. You mentioned that actual header in excel so, please share more details about this query it will help to validate further. 

 

Regards, 

Balaji Sekar 

[Cheryl Barber]

Sorry for the delay. As you can see from the attached pictures, it takes the items that are being sent in the "header" section and places them in the first few rows of the excel sheet... not in the true header of the excel.

Attachment: Examples_4681eef8.zip

[Balaji Sekar]

Hi Cheryl,  

We do not have Support to set Header and Footer in Excel document using EJ2 Excel export. Currently, we don’t have any plans to implement this feature. However, we have logged a feature report for this and you can track the status of feature report through following feedback link.  

Track Status: https://www.syncfusion.com/feedback/25572/support-to-set-header-and-footer-in-excel-document-using-ej2-excel-export  

Regards,  

Balaji Sekar 

[Cheryl Barber]

Thank you!!

[Balaji Sekar]

Hi Cheryl, 

  

Thanks for your update. 

  

Please get back to us if you require further other assistance from us. 

  

Regards, 

Balaji Sekar.