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
Ravi
700
Group by Rows - Excel Export
posted
Hi, I am using version 7.2. We have a databound UltraGrid in which the records are grouped by one column. When I export this grid to excel, it is grouped there as well (which is what we want) but all the groups are collapsed. But we want it to be expanded always irrespective of the grid property. How to do that ? Refer image, we have 2 buttons on top left as 1 & 2 when clicked on 2 it expands. Thanks.
Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    Hi,

    Try this:


            private void ultraGridExcelExporter1_EndExport(object sender, Infragistics.Win.UltraWinGrid.ExcelExport.EndExportEventArgs e)
            {
                foreach (WorksheetRow row in e.CurrentWorksheet.Rows)
                {
                    row.Hidden = false;
                }
            }

Children