I have a RadGridView which I've used the property builder to add several groups to.When I hide the group, it hides the columns within the group on screen, however when I export the grid to excel, the columns within the group are still visible.
Is there anyway of fixing this so that if the group is hidden, the columns within the group are not exported?
I already have:
Dim exporter As ExportToExcelML = New ExportToExcelML(Me.grid)
exporter.HiddenColumnOption = Telerik.WinControls.UI.Export.HiddenOption.DoNotExport
exporter.SheetName = "Export"
exporter.SummariesExportOption = SummariesOption.DoNotExport
Dim filename As String = "C:\Export.xls"
exporter.RunExport(filename)