I have one excel which has more than 50,000 records. Now I want to highlight cell of those excel which matches with my condition. What would be the fastest way to update it?. Is it using SetColor Range within for each record?
Fastest way to highlight excel cell with a color in UiPath
First of all try uipath activity to set color range, but you are checking conditions so i am assuming you will check every particular record, so you can go for either VBA or Use Invoke code vb.net.
Use invoke VBA activity and write an VBA macro it will be much faster…
Appreciate if u could share sample of how to do it.
Appreciate if you Could share sample code on how to do it