cancel
Showing results for 
Search instead for 
Did you mean: 

Excel formatting

BhavyaTaneja
Level 3
Hi All,

Has anybody performed formatting in excel using Blue prism e.g. Bold, Italics, Underline, auto-fit etc. ?

------------------------------
Bhavya Taneja
------------------------------
1 BEST ANSWER

Helpful Answers

Hi @Bhavya Taneja,

You can refer below video to achieve the functionality of Auto-fit feature in Excel:

https://www.youtube.com/watch?v=vClUWFM4Yog

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

View answer in original post

6 REPLIES 6

ManpreetKaur1
Level 8
Hi @Bhavya Taneja,

Did you try code stage to achieve the functionality?
You can easily achieve the formatting by writing a .net code.​

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

Hi @ManpreetKaur1,

Thanks for your response. Do you have any sample code for achieving the similar functionality?​
I tried achieving the functionality but it's not working.

------------------------------
Bhavya Taneja
------------------------------

Hi @Bhavya Taneja,

You can refer below video to achieve the functionality of Auto-fit feature in Excel:

https://www.youtube.com/watch?v=vClUWFM4Yog

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

Thanks a lot @ManpreetKaur1.
It really worked​ !!
I will try to write the similar code for achieving other functionalities as well.

------------------------------
Bhavya Taneja
------------------------------

Good to know it worked 🙂

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

Hi Bhavya,

Are you sure if you are using the latest updated MS Excel VBO because it already has this action without you to create any custom code stage. You can download the asset from Digital Exchange: MS Excel VBO

Also, you can check the user guide for more details:

21320.png

For formatting any specific cell as Bold, Italic or Underlined, you can create code stages. One such example is in the following thread: Make Cell Font Bold

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.