PivotGrid Export to Datatable

[Khalid]

is it possible to export the Pivot Data to datatable or datasource.

similarly like DevExpress pivot table.
https://documentation.devexpress.com/#WindowsForms/DevExpressXtraPivotGridPivotGridControl_CreateSummaryDataSourcetopic

 

[Hristo]

Hello Khalid,

Thank you for writing.

This type of functionality is not yet supported. You can, however, iterate the added row and column groups, for example like this: 

List<string> columns = new List<string>();
this.radPivotGrid1.PivotGridElement.SuspendLayout(true);
PivotGridGroupTraverser traverser = (PivotGridGroupTraverser)this.radPivotGrid1.PivotGridElement.ColumnScroller.Traverser.GetEnumerator();
traverser.Reset();
while (traverser.MoveNext())
{
    columns.Add(traverser.Current.Name);
}

this.radPivotGrid1.PivotGridElement.ResumeLayout(true, true);

The pivot cells can be extracted by using the RadPivotGrid.PivotGridElement.GetCellElement method. You need to pass as parameters appropriate row and column nodes.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik by Progress