Coloring excel cells taking long time

excel
p_qa

#1

I want color excel cells with RED color but the cells are not in sequence. I’m iterating in an array list which contains cell values to be colored and to color 1000*33 cells, robot took 10 hours. Is there any way to fasten the process ?


#2

Can you attach your xaml, i will try do some research and let you know.


#3

So its 33000 cells in about 36000 secs. 1 sec per cell.
This needs to be checked.


#4

Excel_coloring.xaml (10.2 KB)

attached sample flow which we used in our code. Kindly check


#5

Example_coloring_excel_output.zip (89.5 KB)

Attached output excel for reference.