is it possible to customize only the first header row and not the second header row when exporting to excel? Also when customizing the text for the header row, is it possible to specify the colspan? I couldn’t find anyway to merge and center 3 cells in the header when exporting.
Yes, it’s possible to use colspans during export. For these needs you should not only define a colspan value for a column header, but also define null header for the columns that are included into this colspan.
In fact header configuration consists of an array of header rows: