Grid - Remove Column Groups From Export

Posted by: mihaimelencu on 12 September 2024, 3:15 am EST

  • Posted 12 September 2024, 3:15 am EST

    Hello,

    I’m currently working on a project where I need to I have column groups and I need to export the grid data to Excel, while excluding the column groups from the export.

    I’m running into issues when trying to export the FlexGrid data to Excel using FlexGridXlsxConverter. I need to exclude the column groups from the export and only export the actual data columns.

    I’ve tried various solutions with the* includeColumns *function to exclude the parent (group) columns, but it either exports an empty file or includes the group headers, which I want to avoid.

  • Posted 13 September 2024, 6:48 am EST

    Hi,

    We are unable to replicate the issue on our end, as no such issue is observed on our side. However, you can refer to the following sample that demonstrates how you can include/exclude column group headers in the exported Excel file - https://jscodemine.mescius.io/share/FcyprBGjBUa5BTKHX1d78A/

    In the above sample, ‘includeColumnHeaders’ option is used to add/remove the column groups in exported Excel file, here’s the API link for the same for your reference - https://developer.mescius.com/wijmo/api/interfaces/wijmo_grid_xlsx.iflexgridxlsxoptions.html#includecolumnheaders

    In case, if there is something we missed, please let us know.

    Regards

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels