Below links would help to achieve the same. They are in Visual Basic. If you wish to write in C# then you would need to convert the same.hi,
I want to write a code such that it formats the excel file like font-color of some particular cells, cell colors of a particular column etc using c# code stage in blue prism.
Please help
The easiest would be to use Excel VBA instead of C# for any excel related coding.Thank you for the reply. but how to convert it in c#? now that's an issue for me.
For coding in VB in blue prism, what all references and imports should i add in the initialise page of the object??The easiest would be to use Excel VBA instead of C# for any excel related coding.
You have to extend the existing Excel VBO and add a new page with Code stage and necessary code you need to format the worksheet. Once you publish the newly created page. You can use this as any other action in Excel VBO.
Hope this helps!
No, can you just brief me with the steps to do this?Have you created a new object or extending Excel VBO by taking a copy of any other pages?
You can make a copy of the existing 'Format Cell' action of the MS Excel VBO.
Remove the existing code and add the below line to the Code stage.
Code:GetWorkbook(handle,Nothing).ActiveSheet.Range(cellref,cellref).Interior.Color = RGB(Red_Value, Green_Value, Blue_Value)
Yes i did what you asked for. The 2 errors which i mentioned in my post #7 persists. GetWorkbook and RGB error.Check VJR post whcih says to-