exporting hieararchical gridview

[AAA]

 How to not Export specified columns for each parent row child rows when exporting to excel in telerik radgridview ui winf

 

I a have hierarchical telerik radgridview in winform. in this radgridview master template i have a rows that each row has child rows that are null in some columns for all child rows of that parent row and not for others.

I wrote a code that only let one parent row to be expanded and when expanding that parent row show only the columns that has value at least in one child row and hide columns that its child rows are all null for that parent row with radGridView1_ChildViewExpanded event handler.

My problem is when i want to export this hierarchical telerik radgridview to excel file. what should i do in exporting to achieve to what i described, means exports only the columns that have at least one value in its child rows and not export others for each parent row.

tnx

[AAA]

I used this code and it worked

void spreadExporter_CellFormatting(object sender, Telerik.WinControls.Export.CellFormattingEventArgs e)
{
  if (e.GridRowInfoType == typeof(GridViewHierarchyRowInfo))
  {
    int i = 0;
    foreach (GridViewColumn column in radGridView1.MasterTemplate.Templates[0].Columns)
    {
     if (i > 1)
     {
      int TotalNullRecords = (from row in e.GridCellInfo.RowInfo.ChildRows
      where string.IsNullOrWhiteSpace(row.Cells[column.Name].Value.ToString())
      select row).ToList().Count;

      if (TotalNullRecords == e.GridCellInfo.RowInfo.ChildRows.Count)
      {
       radGridView1.MasterTemplate.Templates[0].Columns[column.Name].IsVisible = false;
      }
      else
      radGridView1.MasterTemplate.Templates[0].Columns[column.Name].IsVisible = true;
   }
   i++;
  }
 }
}

 

[Dimitar]

Hello,

Thank you for writing. 

I am glad that you have found a solution for this. Nevertheless, the other possible way is to manually export the grid. We have an example for this in our demo application (see attached image). 

Detailed information about the Spread Processing library is available here: Overview.

I hope this will be useful. 

Regards,
Dimitar
Telerik by Progress