Export Column Groups Text in Excel

[Muhammad]

Hi again,

I'm new to working with column groups in Telerik.

I wanted to export my grid, but I can't show column group text in the output excel file.

 

I tried simple usage of exporter:

var excelML = new Telerik.WinControls.UI.Export.ExportToExcelML(grid);
excelML.RunExport(filedialog.FileName);

 

but I don't know how to customize it

[Hristo]

Hi Muhammad,

The ColumnsGroupViewDefinition is not supported by the ExportToExcelML class. The preferred way to export the grid is to use the GridViewSpreadExport and GridViewSpreadStreamExport classes. The synchronous export method of the new spread export engine also supports ColumnsGroupViewDefinition. More information is available here: https://docs.telerik.com/devtools/winforms/gridview/exporting-data/spread-export.

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

Regards,
Hristo
Progress Telerik