topic Re: Excel formatting in Product Forum

Excel formatting

BhavyaTaneja — Wed, 04 May 2022 18:07:48 GMT

Hi All,

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

Re: Excel formatting

ManpreetKaur1 — Wed, 04 May 2022 18:58:33 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

Similarly, you can try achieving the other formatting functionalities by writing the C# or vb.net code

Re: Excel formatting

devneetmohanty07 — Wed, 04 May 2022 19:18:58 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