Digital Exchange

 View Only
last person joined: yesterday 

This community is a place to discuss Blue Prism DX assets and development.

  • 1.  Excel VBO - Creating Extra Code Stages

    Posted 20 days ago
    Morning all.

    I'm in need of formatting a range of cells within an Excel document - font type, size, unbolding etc. I can see that unbolding is an option on the Extended VBO, but not for amending the font. If I were to go about creating additional code stages to add this functionality (and bear in mind that I'm a complete novice with minimal coding experience in Python), is there some sort of guide that outlines the available functions, sub-routines and arguments that can be called? Or (and my fingers are very crossed here!), has somebody already made code stages that already add this functionality?

    Cheers!

    ------------------------------
    John Hammond
    ------------------------------


  • 2.  RE: Excel VBO - Creating Extra Code Stages
    Best Answer

    Posted 20 days ago

    Hi John, creating your own actions with inspiration from the "Bold Font" action is doable.

    For example, if you want to change the font, you can duplicate the action and add the following input: FontName

    In the codestage, you map the input and pass it to the Font.Name code.

    You can do this for all the font properties, see attached.



    ------------------------------
    Mats Holm Pettersson
    RPA Specialist
    WillisTowersWatson
    Europe/Copenhagen
    ------------------------------



  • 3.  RE: Excel VBO - Creating Extra Code Stages

    Posted 20 days ago
    Thank you Mats! I was trying to do similar to what you suggested but using the 'Format Cells in Range' action from the standard Excel VBO, but this made much more sense to me and was actually quite simple!

    ------------------------------
    John Hammond
    ------------------------------



  • 4.  RE: Excel VBO - Creating Extra Code Stages

    Posted 17 days ago
    Thanks @Mats Holm Pettersson for sharing the code stage. It's really helpful​​

    ------------------------------
    Manpreet Kaur
    Manager
    Deloitte
    ------------------------------



Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support

FAQs

The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.