Articles in this section
Category / Section

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?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied