Blank row added when Export to Excel from Heirarchy grid

The child rows of the grid are indented on the screen, so the child rows are indented one column in Excel. The extra spaces appear to be intentionally put there to separate the child rows from the parent rows, just like they are separated by a space on-screen.

If you wanted to remove the indentation of the band in the on-screen grid, you would set the Indentation on the bands. Something like this:

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            foreach (UltraGridBand band in e.Layout.Bands)
                band.Indentation = 0;
        }

But you probably don't want this to affect the on-screen grid, only the export, so you could use the export layout. Like so:

        private void ultraGridExcelExporter1_BeginExport(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.BeginExportEventArgs e)
        {
            foreach (UltraGridBand band in e.Layout.Bands)
                band.Indentation = 0;
        }

This will eliminate the indentation of the export layout and thus the exported excel file.

To remove the row spacing is a little trickier. It looks like you have set up your grid to not have spaces between islands but you on;y have one set of column headers. There are a couple of different ways you could have done this, and I can't tell just by looking at the screen shot. Maybe this is OutlookGroupBy or maybe it's using a combination of the ColHeaderVisible on the Band and the HeaderPlacement properties. On my machine when I set this up in the latter way, the extra spaces are not there.

These extra lines could also be caused by a RowLayout that has extra Spans in it, but that would only happen in an older version of the grid, as this was fixed a while ago.

In any case, you probably just need to adjust the CurrentRowIndex when these spaces are occurring. Something like this:

        private void ultraGridExcelExporter1_RowExporting(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.RowExportingEventArgs e)
        {
            // Don't do anything for root-level rows
            if (e.GridRow.Band.Index != 0)
            {
                // Is this the first row in the island.
                if (e.GridRow.HasPrevSibling() == false)
                {
                    e.CurrentRowIndex -= 1;
                }
            }
        }