Feedback by UserVoice

I suggest you ...

Special Cells method

In Excel API, I can't choose cells based if they have formulas or values.

In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.

Please, support this for Excel JavaScript API, because currently, I'm looping all the worksheet's used range rectangle to get the values, and my loops spend a lot of time skipping blank cells.

33 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Felipe Costa Gualberto shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Felipe Gualberto commented  ·   ·  Flag as inappropriate

        Nice, thanks! It would be great to have a documentation listing the possible values of enumerations SpecialCellType and SpecialCellValueType.

      Feedback and Knowledge Base