Get Selected Range Value

Get Selected Range Value

Posted by: oskarputraa on 2 October 2019, 8:20 am EST

• 

  oskarputraa

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 October 2019, 8:20 am EST - Updated 3 October 2022, 7:10 pm EST

  Hi,

  I would like to get each selected range value, cell (D2, E2, F2, … F5)

  

  1326×465 9.68 KB

  Could you help with that ?

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 3 October 2019, 12:45 am EST

  Hi Oskar,

  You may use the selection property of the FlexSheet to get the currently selected range of cells. The selection property is a type of CellRange class that provides information about a range of cells. It contains properties like leftCol, topRow, etc, and you may iterate over each cell using these properties.
  
  Also, if you have multiple selection ranges, then you may use the selectionRanges property of Sheet class. It is an instance of ObservableArray of CellRange class. Please refer to the links below for reference:

  API Reference:

  • "* “CellRange: https://www.grapecity.com/wijmo/api/classes/wijmo_grid.cellrange.html”
  • “selection property: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.flexsheet.html#selection”
  • “selectionRanges property: https://www.grapecity.com/wijmo/api/classes/wijmo_grid_sheet.sheet.html#selectionranges”
    
    "

  Let me know if you have any other queries.

  Regards,
  
  Ashwin