Digital Exchange

last person joined: 2 hours ago 

This community is a place to discuss the Blue Prism DX and all of the assets hosted there.
Expand all | Collapse all

How to Apply formula to entire cell using Blueprism

  • 1.  How to Apply formula to entire cell using Blueprism

    Posted 09-17-2020 00:39
    Hi , I am trying to apply formula to entire cell in Excel from Blueprism.

    I was able to paste the formula in one of the cell(M7) using Set Cell Value. Is there any option to fill the entire cell (M7:M[lastRow])?

    ------------------------------
    Asia/Kolkata
    ------------------------------


  • 2.  RE: How to Apply formula to entire cell using Blueprism

    Posted 09-17-2020 01:12
    Hi,

    You could also use the AutoFill action in the MS Excel VBO Extended to fill the formula up to the desired row.

    ------------------------------
    Shashank Kumar
    DX Integrations Partner Consultant
    Blue Prism
    Singapore
    +6581326707
    ------------------------------



  • 3.  RE: How to Apply formula to entire cell using Blueprism

    Posted 09-17-2020 02:19
    Hello

    You could use the action "Apply formula in Range" present in the "SPGMI - MS Excel Booster" vbo

    ------------------------------
    Nupur Sood
    Research Associate
    S&P
    Asia/Kolkata
    ------------------------------