Solved Formatting Excel in Blue Prism

[KaliRaj1982]

I need format the Excel workbook like below,

1. Background Color and Foreground Color
2. Bold the Text
3. Create Empty Rows
4. Cell styles
5. Apply Borders and Etc.......

How to achieve above in BluePrism

 

[anisjolly]

Hi @KaliRaj1982

Have you tried to use Excel shortcut keys when selecting cells and rows?

 

[KaliRaj1982]

How to use that shortcut keys in Blueprism

 

[GavBot]

You will need to use the excel vbo object
Blue Prism have extended versions of this or you will need to mature/develop your own objects to achieve this.

 

[anisjolly]

@KaliRaj1982 - @GavBot's answer is what you're looking for. However, if you need to develop your own objects to achieve this then the Excel Object Model will help point you in the right direction. This Model provides examples of code you could use to achieve what you need.

 

[sharathswt]

Hi All,
Did anyone have the matured Excel VBO which can handle the Bold, Merge, Color ,Font ?
Could you please share the code stage please. This will really help a lot .

Thanks in advance .

Sharath