topic Detect colored Cells in Excel in Product Forum

Detect colored Cells in Excel

NicolasSahli — Tue, 14 Jan 2025 12:15:01 GMT

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!

Re: Detect colored Cells in Excel

Mohamad_Dakkouri — Tue, 14 Jan 2025 13:11:36 GMT

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 ?

Re: Detect colored Cells in Excel

herminio217 — Tue, 14 Jan 2025 14:44:55 GMT

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

Re: Detect colored Cells in Excel

NicolasSahli — Tue, 14 Jan 2025 14:49:40 GMT

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