Excel formatting

[BhavyaTaneja]

Hi All,

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

[ManpreetKaur1]

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

[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