Export Column Groups Text in Excel

2 posts, 0 answers
  1. Muhammad
    Muhammad avatar
    2 posts
    Member since:
    Sep 2016

    Posted 24 Sep 2018 Link to this post

    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

  2. Hristo
    Admin
    Hristo avatar
    1510 posts

    Posted 25 Sep 2018 Link to this post

    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
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

Back to Top