Grid - Remove Column Groups From Export

Grid - Remove Column Groups From Export

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

• 

  mihaimelencu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  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