Export excel in grouping ?

[kannan]

Hi,

I am using Export excel in RadGridView. when i am going to export excel after grouping the column, the datas are not correctly exported in the excel file.

i have used the below code:

 

 

SaveFileDialog dlgFile = new SaveFileDialog();

 

dlgFile.Filter =

 

 

"Excel files|*.xls";

 

dlgFile.DefaultExt =

 

 

"xls";

 

dlgFile.FilterIndex = 1;

 

 

 

 

if (dlgFile.ShowDialog() == true)

 

{

 

 

 

using (Stream stream = dlgFile.OpenFile())

 

{

 

 

 

GridViewExportOptions exportOptions = new GridViewExportOptions();

 

exportOptions.Format =

 

 

ExportFormat.ExcelML;

 

exportOptions.ShowColumnFooters =

 

 

true;

 

exportOptions.ShowColumnHeaders =

 

 

true;

 

exportOptions.ShowGroupFooters =

 

 

true;

 

gridview.Export(stream, exportOptions);

}

}

But my excel file displays the datas ( see the Atttached file "Image1" )
But The excel file should display the data like ( see the Atttached file "Image2" )

 

[kannan]

Hi,

 i have changed my source code . the grouped column displayed the record in footer of the row.But i have to display that value in header of the row.
when i debug the below code, the condition is false.

if(e.Element ==

 

ExportElement.GroupHeaderCell)

 

{
          // This condition is false;
}

can you please explain ?

please see the attatched file

[Michael Rogers]

Hi Kannan,

Did you figure out what is causing this i have the same problem.

Thanks
Michael