Yes, I tried that but the Excel Exporter throws an error stating a key isn't found. I assume it is still trying to use the Band[1] column keys during export.

I am going to try this to see if I can get around it.

 private void OnInitializeRowDataExcelExporter(object sender, ExcelExportInitializeRowEventArgs e)
 {
     e.SkipDescendants = SkipChildBandExcelExport;
 }

Hi, you can hide the Band in BeginExport event of UltraGridExporter

like this

 private void OnGridBeginExport(object sender, BeginExportEventArgs e) {
    e.Layout.Bands[1].Hidden=true;
    }

Hi Mike,

If there are two bands but I only want band[0] to export, how can I make that happen?

thanks

-Ken