custom headers while using runexport method to excel

[nazeer syed]

ExportToExcelML exporter = new ExportToExcelML(radgridview);
                exporter.ExportVisualSettings = true;
                string filePath = "c:\test";
                string filename = "myfilename" + ".xls";
                exporter.RunExport(filePath + "\\" + filename);

 

using the above snippet how to insert a custom HEADER rows in Excel 

 

 

[Hristo]

Hi Nazeer,

Thank you for writing.

From your code snippet, I see that you are using the old ExportToExcelML class. Please note that we also have the GridViewSpreadExport class which is natively exporting to the .xlsx format thanks to the DPL libraries. The spread processing engine in the libraries is more powerful so I strongly recommend that you switch to using the spread export: http://docs.telerik.com/devtools/winforms/gridview/exporting-data/spread-export.

Using the GridViewSpreadExport class you would be able to create headers and footers according to the example demonstrated here: http://docs.telerik.com/devtools/winforms/gridview/exporting-data/how-to/add-
header-and-footer-to-the-exported-document.

Still, in case you need to stick to the old exporting engine you can create headers and footers by handling the ExcelTableCreated event: http://docs.telerik.com/devtools/winforms/gridview/exporting-data/export-to-excel-via-excelml-format#events.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Progress Telerik