topic RE: Excel formatting in Product Forum

Excel formatting

BhavyaTaneja — Wed, 04 May 2022 17:59:00 GMT

Hi All,

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

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

RE: Excel formatting

ManpreetKaur1 — Wed, 04 May 2022 18:10:00 GMT

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

RE: Excel formatting

BhavyaTaneja — Wed, 04 May 2022 18:14:00 GMT

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

RE: Excel formatting

ManpreetKaur1 — Wed, 04 May 2022 18:19:00 GMT

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

RE: Excel formatting

BhavyaTaneja — Wed, 04 May 2022 18:54:00 GMT

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

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

RE: Excel formatting

ManpreetKaur1 — Wed, 04 May 2022 18:59:00 GMT

Good to know it worked 🙂

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

RE: Excel formatting

devneetmohanty07 — Wed, 04 May 2022 19:17:00 GMT

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

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