CODEWITHSUNDEEP
infragisticsultrawingrid
Fatih Elmali
Fatih Elmali

Reputation: 59

UltraGrid Child Bands

I would like to move the child bands of a master band to the very left when exporting to excel using ExcelExporter.

Right now, all the child bands are displaced one column to the right.

Also, each child band has a blank row above and below it. I would like to remove them as well.

is this possible?

Thanks

enter image description here

Upvotes: 0

Views: 977

Answers (1)

Fatih Elmali
Fatih Elmali

Reputation: 59

Private Sub UltraGridExcelExporter1_BeginExport(sender As System.Object, e As Infragistics.Win.UltraWinGrid.ExcelExport.BeginExportEventArgs) Handles UltraGridExcelExporter1.BeginExport
    DirectCast(sender, UltraWinGrid.ExcelExport.UltraGridExcelExporter).BandSpacing = UltraWinGrid.ExcelExport.BandSpacing.None

    For Each band As UltraWinGrid.UltraGridBand In e.Layout.Bands
        band.Indentation = 0
    Next

End Sub

Upvotes: 2

Related Questions