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
Arun
475
excel export issue when grid is having hierarchical data
posted

Hi I am having a grid which was binded with a hierarchical data and the number of maximum bands expected are 4.

On screen this is looking fine with a expanded +/- symbol. I am using UltraGridExcelExporter control to export to excel.

after I export to excel, in the excel sheet only the first band data are in proper places. the second or further band data (i.e child band data) or skipping one column from the parent row and the readability is lost.

attached the screenshot for your reference.

 

What we want is the + symbol should be expanded in the excel but all the child bands should be plotted from column A.this is applicable for all child bands. i.e all the child bands should be plotted from Column A.

any suggestion please.

Thanks,

Arun.K.S

  • 469350
    Suggested Answer
    Offline posted

    Hi Arun,

    Handle the BeginExport event on the UltraGridExcelExporter. This event will pass you a Layout which is a clone of the grid layout. Since it's a clone, you can modify the layout without affecting the on-screen grid - it will only affect the export.

    So you can loop through the Bands collection on the layout and set Indentation on each band to 0.