How to find out particular column from the whole BI PivotGrid

2 mins read

Our pivot grid displays the data through pivot engine based on Pivot Rows, Pivot Columns and Pivot Calculations. And we could retrieve the each cell’s model using internal grid and stores as column collection.

For example, please find the below code snippet to illustrate the same.

Dictionary<string, List<GridStyleInfo>> columnsDictionary = new Dictionary<string, List<GridStyleInfo>>();

for (int i = 0; i < pivotGridControl1.PivotEngine.ColumnCount; i++)

{

List<GridStyleInfo> listOfCells = new List<GridStyleInfo>();

for (int j = 0; j < pivotGridControl1.PivotEngine.RowCount; j++)

{

listOfCells.Add(pivotGridControl1.InternalGrid.Model[j, i]);

}

columnsDictionary.Add("Column" + i.ToString(), listOfCells);

}

Did you find this information helpful?

Yes

Comments (0)

How to find out particular column from the whole BI PivotGrid

Access denied