Excel formatting

[BhavyaTaneja]

Hi All,

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

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

[ManpreetKaur1]

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
------------------------------

[BhavyaTaneja]

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
------------------------------

[ManpreetKaur1 · Accepted solution]

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
------------------------------

[BhavyaTaneja]

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

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

[ManpreetKaur1]

Good to know it worked 🙂

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

[devneetmohanty07]

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:



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

----------------------------------
------------------------------