)
We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to select cells or rows or columns in pivot table at code level in WinForms PivotGridControl?

Platform: WinForms |
Control: PivotGridControl |
Published Date: January 27, 2015 |
Last Revised Date: January 7, 2020
Tags: selection

Selection

The PivotGridControl supports selecting the range of Cells/Rows/Columns or particular Cell/Row/Column.

Solution

The selections can be defined by using PivotGridControl’s TableModel property. The cells/rows/columns can be selected by giving correct range to the Selection (which cells or range to be selected). The Range for the selections can be provided as GridRangeInfo.

C#

//To Select range of Cells
this.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Cell(4, 3));
 
//To Select range of Column
this.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Col(5));
 
//To Select range of Row
this.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Row(9));

VB

'To Select range of Cells
Me.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Cell(4, 3))
 
'To Select range of Column
Me.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Col(5))
 
'To Select range of Row
Me.pivotGridControl1.TableModel.Selections.Add(GridRangeInfo.Row(9))

Samples

C#: Selection CS

VB: Selection VB

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Up arrow icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon