Hi!
I have a datatable from an excel and I only need to do the process in the rows which have no color in any cell.
Could you help me, please, with the condition I have to write in the if activity?
Thank you very much in advance.
Regards
Hi!
I have a datatable from an excel and I only need to do the process in the rows which have no color in any cell.
Could you help me, please, with the condition I have to write in the if activity?
Thank you very much in advance.
Regards
Any playing with color has to happen in Excel, before the datatable is created. By default, datatable can not store any color/formatting information.
To check color in Excel, you can use: “Get Cell Color” or “Get Range Color” activities
Loop through each cell row wise, OR consider one row as a range and check color, if no color, add row to datatable.