Rank 2
Iron
Iron
Iron
Hi,
I have gridview in which I added some common group headers to group the columns logically. Depending on the context some of these logical groups have no data and therefore I hide them in the UI (IsVisible=false on DataLoaded event). On exporting the grid to Excel (.ExportToXlsx method) the Group Headers does not line up with the relevant columns. I put this down to the hidden columns so my solution was to first show all the columns (IsVisible=true), do the export and then hide the relevant empty columns again. However, now none of the group headers are exported.
I capture the ElementExportingToDocument event and can see a CommonColumnHeaderRow element being exported but no CommonColumnHeaderCell element or the like (next element is HeaderRow).
Any thoughts?
2 Answers, 1 is accepted
Rank 2
Iron
Iron
Iron
UPDATE:
I have moved showing all columns to before calling the FileDialog for the destination and now it works as expected. So it seems like a timing issue.
While this addresses my workaround, ideally I would like not to export the empty columns but be able to keep the headers lined up
I am glad that you managed to find a resolution to the question from your first post.
As to your second requirement, we have it already logged in our Bug tracking system. You can track its progress in the Feedback portal: Add support for disabling the export of a particular column.
Do not hesitate to contact us in case you have any other questions on our controls.
Best Regards,
Stefan X1
Telerik