I have an Excel document “Test.xlsx” which has 15 columns starting from “IR” all the way to “JF”. It is very important it starts and end at these specific columns.
The data in the Test.xlsx comes from a data table variable dt.
Inside the data table variable dt there is a lot of information, however, I am only curious about the information which is incorrect. The excel sheet has to only have numbers in it, the moment something else than numbers show up, as for example letters, then I need to mark that cell red. How can I do this in UiPath?
Ps. I know I can do this inside a Assign variable…
Pss. Nothing in the data table can change. This means, the data/ information has to be at the same places/ cells as the original excel sheet. So no swaping of columns, rows, cells, deleting or adding something. Only the colour of the individual cells which are incorrect can change.
All help and guidance is gladely appreciated. Have a great day/ night forward.
You can iterate on DT and make if condition if this cell has numbers or no and you can use above mentioned regex or you can find below solution in mentioned in URL then if this contains letters you can add color to cell and find solution in below URL hope this answer help you
“Argument ‘Condition’: Compiler error(s) encountered processing expression “not CurrentRow.ByIndex(currentItem-2).ToString.IsNumeric”. Option Strict On prohibits the use of operands of the type Object for the operator ‘-’”
I got an unexpecting behaviour when trying to implement your solution. My program ALSO changes colour of the blank cells. I forgot to point out, that cells which has anything else than numbers in it has to be colored. Blank cells and cells with only numbers are accepted and should not change colour.