How to remove excel cell color

Help
1

How do i remove excel cell color after using set range color on it?

Any help is appreicated

2

@zhongyong11 again use set range color and mention ur required range and color as white. I think this work and try it once.

2 Likes
3

@zhongyong11

Use the same activity again with a different color.

Regards,
Karthik Byggari

4

I wan the excel to revert to it original color. Which has no color

5

@zhongyong11

If you want to reset the color, set the color to white. It is the default color pattern in Excel.

Regards,
Karthik Byggari

6

okay will give it a try. Thanks

7

you can use system.drawing.color.white or system.drawing.color.transparent but the thing is it will remove your cell border.

3 Likes
8

You can try this with Macros as well. Create a macro to do your task and execute it from UiPath Studio

Thanks,
Prankur

1 Like
9

I have encountered the same trouble which the cell color should be none.
Just like other’s recommendation , “system.drawing.color.white” is not the answer.
But I found that with some excel operation steps ,this can be revolved.
If you still be in trouble,
I can give you a sample to solve this problem.

10

Do you still have the solution? Would be helpful to share :slight_smile:

11

Try this xaml.
With studio is 2020.10.2,Excel is Microsoft365.
ExcelOperation.zip (77.4 KB)