[Solved] Export to Excel - Change GroupHeaderRow and GroupFooterRow's Style for each group

[Software]

Hello,

I would like to change the style of GroupHeaderRow and GroupFooterRow for each group in ElementExportingToDocument event.

Could you help me to to this please ?

Thanks a lot

Regards.

ie : 

private void ElementExportingToDocument(object sender, GridViewElementExportingToDocumentEventArgs e)
        { if (e.Element == ExportElement.GroupHeaderRow )
            {
//-----------------------------------------------------
// How to know here in witch group I am ??
//-----------------------------------------------------
Color MyColorGroup = ColorSwitchGroup(thisgroup);

                (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle()
               {
                   FontSize = UnitHelper.PointToDip(11),
                   IsBold = true,


                   Fill = new PatternFill(PatternType.Solid, MyColorGroup ,MyColorGroup ),
                   CellBorders = CellBorders.CreateOutline(new CellBorder(CellBorderStyle.Thin, new ThemableColor(Colors.Black)))
               };
            }
            else if (e.Element == ExportElement.GroupFooterRow)
            {
//-----------------------------------------------------
// How to know here in witch group I am ??
//-----------------------------------------------------
Color MyColorGroup = ColorSwitchGroup(thisgroup);
                (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle()
                {
                    FontSize = UnitHelper.PointToDip(11),
                    IsBold = true,
                    Fill = new PatternFill(PatternType.Solid, MyColorGroup , MyColorGroup ),
                    CellBorders = CellBorders.CreateOutline(new CellBorder(CellBorderStyle.Thin, new ThemableColor(Colors.Black)))
                };
            }
   }

[Vladimir Stoyanov]

Hello Olivier,

For the GroupHeaderRows you can cast the GridViewElementExportingToDocumentEventArgs' DataContext to a QueryableCollectionViewGroup and then use its Key property.

As for the GroupFooterRows you can cast the DataContext to an AggregateResultCollection and then match it with the correct group from the all the groups in the RadGridView. Here is how that would look:

private void RadGridView_ElementExportingToDocument(object sender, Telerik.Windows.Controls.GridViewElementExportingToDocumentEventArgs e)
        {
            if (e.Element == ExportElement.GroupHeaderRow)
            {
                var group = e.DataContext as QueryableCollectionViewGroup;
                var key = group.Key;

                //Color MyColorGroup = ColorSwitchGroup(thisgroup);
                (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle()
                {
                    FontSize = UnitHelper.PointToDip(11),
                    IsBold = true,
                    //Fill = new PatternFill(PatternType.Solid, MyColorGroup, MyColorGroup),
                    CellBorders = CellBorders.CreateOutline(new CellBorder(CellBorderStyle.Thin, new ThemableColor(Colors.Black)))
                };
            }
            else if (e.Element == ExportElement.GroupFooterRow)
            {
                var group = e.DataContext as AggregateResultCollection;
                var groups = this.gridViewExport.Items.Groups;
                QueryableCollectionViewGroup currentGroup = GetCurrentGroup(group, groups);
                var key = currentGroup.Key;

                //Color MyColorGroup = ColorSwitchGroup(thisgroup);
                (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle()
                {
                    FontSize = UnitHelper.PointToDip(11),
                    IsBold = true,
                    //Fill = new PatternFill(PatternType.Solid, MyColorGroup, MyColorGroup),
                    CellBorders = CellBorders.CreateOutline(new CellBorder(CellBorderStyle.Thin, new ThemableColor(Colors.Black)))
                };
            }
        }

Here is the method for recursively getting the correct group from all of the RadGridView groups:

private QueryableCollectionViewGroup GetCurrentGroup(AggregateResultCollection aggregateResults, IEnumerable<object> groups)
       {
           foreach (QueryableCollectionViewGroup group in groups)
           {
               if (group.AggregateResults == aggregateResults)
               {
                   return group;
               }
               else if (group.HasSubgroups)
               {
                   var foundSubgroup = GetCurrentGroup(aggregateResults, group.Subgroups);
                   if (foundSubgroup != null)
                   {
                       return foundSubgroup;
                   }
               }
           }

           return null;
       }

Please let me know if such an approach would be suitable for your scenario. If that is not the case, please provide more details on your exact requirement and I will gladly assist you further.

Regards,
Vladimir Stoyanov
Progress Telerik

[Software]

Great ! Exactly what I need.
Thank you Vladimir 
Regards.
Olivier.