You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Formatting
- Thread starter soraj
- Start date
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
For highlighting a cell or range of cells you can use Post #2 in the below link
http://rpaforum.net/threads/excel-cell-color-identification.1039/post-3087
For making the font red you could look at Post #2 here.
http://rpaforum.net/threads/coloring-text-in-excel-file.1324/post-4054
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.
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!
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!
View attachment excel format.png
I am getting the following 2 errors when using the above mentioned code.
Can you help me with that please?
I am getting the following 2 errors when using the above mentioned code.
Can you help me with that please?
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?
Check VJR post whcih says to-
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-
How to get that fixed?
You have to make a duplicate copy of the 'Format Cell' in to Excel VBO object and change the Code with the above line. I am supposing you are creating a new object outside of MS Excel VBO. So, the function is not being recognized.
If you open the MS Excel VBO and go to Initialize page and click on the Object Propoerties, on the Global Code tab there are bunch of functions defined, one of the functions is 'GetWorkbook'. On the new object you are creating there is no function defined in Global Code section, so BP is showing you the error.
Hope this helps!
If you open the MS Excel VBO and go to Initialize page and click on the Object Propoerties, on the Global Code tab there are bunch of functions defined, one of the functions is 'GetWorkbook'. On the new object you are creating there is no function defined in Global Code section, so BP is showing you the error.
Hope this helps!