Detect colored Cells in Excel

[NicolasSahli]

Hi People

I have this task where it needs to be checked if a Cell in excel is colored or not. How can this be solved with Blue Prism? Is the only way to achieve this a self developed code stage or are there other simple work arounds?

Thanks in advance!

[Mohamad_747]

Hello @NicolasSahli 

Yes you need to create a custom code

We can help you.

Do you mean that you want to find the next collored cell ?

[herminio217 · Accepted solution]

Hi @NicolasSahli , you can filter the Excel file by color here like the example below:

You can use this action in MS Excel VBO the action called "Apply Filter - ByColor" then pass the color value

To delete if you have a lot of rows you can got to special to select visible only, also in MS Excel VBO, and use other action to delete

If you want I can explain better about this actions

[NicolasSahli]

Thank you for your Help and Ideas. I ended up just creating a custom code stage which extracts the Value of the Color of the Field.

I did it with that simple line:
ColorValue = GetInstance(ExcelHandle).ActiveCell.Interior.Color