SpecialCells in Excel JavaScript API

Question

In VBA Excel, I can choose cells based if they have formulas or values.

Sub ColorCells()
    Dim rng As Range

    Set rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
    rng.Interior.Color = RGB(200, 200, 200)

    Set rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeFormulas)
    rng.Interior.Color = RGB(0, 200, 1)
End Sub

Also, I can specify if I want to get only text values, numbers, errors and/or booleans.

How can I do that with Excel JavaScript API? It is a pretty important method. Currently, I'm looping all the worksheet's used range rectangle to get the values, and my loops spend a lot of time in blank cells.

Juan Balmori · Accepted Answer · 2018-10-01 16:49:37Z

1

Good news ! SpecialCells functionality is in beta now! We now support range areas and also specialCells please give it a try and send us feedback. https://learn.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-multiple-ranges

answered Oct 1, 2018 at 16:49

Juan Balmori

5,0661 gold badge11 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kim Brandl · Accepted Answer · 2017-12-14 20:08:38Z

1

I don't believe the functionality that you've described is currently available in the Excel JavaScript API. If you'd like to add this feature request to Office Developer Platform UserVoice, other users can vote on it there, enabling the Office PM team to get a sense for overall priority/demand as they plan for future enhancements to the API.

answered Dec 14, 2017 at 20:08

Kim Brandl

13.5k2 gold badges20 silver badges23 bronze badges

2 Comments

Felipe Costa Gualberto Over a year ago

Yes, it is not supported. I've created a link for this idea here: officespdev.uservoice.com/forums/…

Juan Balmori Over a year ago

Please see my latest: this is now in beta !

Collectives™ on Stack Overflow

SpecialCells in Excel JavaScript API

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related