Author Topic: How to select multiple cell value in excel grid  (Read 240 times)

Punit

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 46
    • View Profile
How to select multiple cell value in excel grid
« 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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to select multiple cell value in excel grid
« Reply #1 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

Punit

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 46
    • View Profile
Re: How to select multiple cell value in excel grid
« Reply #2 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.