Hello,

To prevent the Child Band Indentation when exporting a Hierarchical WebGrid to EXCEL, check for the Child Band Key in the UltraWebGridExcelExporter HeaderRowExporting and RowExporting events and set the CurrentColumnIndex to 0.

The following code example demonstrates how:

protected void UltraWebGridExcelExporter1_HeaderRowExporting(object sender,
       Infragistics.WebUI.UltraWebGrid.ExcelExport.HeaderRowExportingEventArgs e)
{
       // Check for the Child Band Key from the Band
       // to set CurrentColumnIndex Indentation to 0
       if (e.Band.Key == "[Child Band Key]")
       {
             e.CurrentColumnIndex = 0;
       }
}

protected void UltraWebGridExcelExporter1_RowExporting(object sender,
      Infragistics.WebUI.UltraWebGrid.ExcelExport.RowExportingEventArgs e)
{
      // Check for the Child Band Key from the GridRow
      // to set CurrentColumnIndex Indentation to 0
      if (e.GridRow.Band.Key == "[Child Band Key]")
      {
            e.CurrentColumnIndex = 0;
      }
}

Please let me know if this helps or if you have any questions.

Sincerely,
Mike D.
Developer Support Engineer
Infragistics, Inc.