Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Min
300
Export multiple bands to excel indent problem
posted

I have several bands and levels in the wingrid, but all bands have exactly the same columns like this:

 

After export to excel, it indent and looks like this:

 

But I don't want the indent because all the columns in different bands are the same

 

how can I get this done?

Thank you very much

  • 71886
    Offline posted

    Hello minqin,

    Could you please review the sample attached to this post and see if it meets your requirements.
    Please feel free to let me know if I misunderstood you or if you have any other questions.

    BandIndentationExport.zip
  • 1850
    Suggested Answer
    posted

    Hi Minqin,

    You will have to handle the BeginExport event for your UltraGridExcelExporter.

    something like this should work:

    void OnBeginExportDataExcelExporter(object sender, BeginExportEventArgs e)

    {

      foreach (UltraGridBand band in e.Layout.Bands)
           band.Indentation = 0;
    }


    -Ken