ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: Punit on July 12, 2024, 05:58:37 pm

Title: How to select multiple cell value in excel grid
Post by: Punit on July 12, 2024, 05:58:37 pm

Hello,
I want to get multiple cell value from an excel as shown in the picture, I can currently get only single cell value.

Title: Re: How to select multiple cell value in excel grid
Post by: paramvir on July 12, 2024, 10:29:19 pm

Multiple cell values in a selected block can be obtained with Range / Selection API

Code: [Select]

var values = grid.Selection().value();

https://paramquery.com/pro/api#method-Range

https://paramquery.com/pro/api#method-Selection

Title: Re: How to select multiple cell value in excel grid
Post by: Punit on July 19, 2024, 05:13:57 pm

i want this selected cell values on double click event in cellDblClick function, with given method when in double click after selecting multiple cell it gets unselected.