Select Multiple Discontiguous Cells / Ranges / RangeAreas in Excel OfficeJS Javascript Add-in

Select Multiple Discontiguous Cells / Ranges / RangeAreas in Excel OfficeJS Javascript Add-in
3

Upvotes

Upvote

 Aug 23 2022
0 Comments 
New

In Excel or via VBA, users can select multiple ranges.  However, in the Javascript API, selecting multiple, discontiguous ranges is not available.  I would love for this to be supported please!

 

Currently: 

- RangeAreas does not have a select() function. 

- Workbook does not have a setSelectedRanges function.  

- Range has select(), but does not allow qualifying multiple cells/ranges as a single range: activeWorksheet.getRange("A1, B2").select(); // fails on getRange()

 

Thanks!

Kyle