I am hoping someone can point me in the right direction. I have a dataset displaying in my RadGrid. When we export to Excel (HTML) I would like to remove some of the rows - based on a DataKeyValue. How/where would I do this?
1. Set a variable when Exporting to Excel - I did this in the ItemCommand Event
2. Check this variable on ItemDataBound event
3. Pull the <tr> out like this: Dim row As TableRow = TryCast(e.Item, TableRow)
4. If you want the row to NOT show in Excel - add this: row.Style("display") = "none"
I want to remove all of the group header rows. I am not sure how to find the Style for this row.
answered on 01 Jul 2019, 04:10 PM
I suggest using the server-side approach for eliminating the ColumnGroups from the exported file.