Thansk Vikas, I’m using “Get OCR Text” activity and using Google as OCR engine. but getting below output. Its not comparable, probably issue with OCR engine, its not recognizing text properly
Another point is, my text will be not visible always (it may be somewhere down in excel sheet)
Using OCR is not a good solution here. Ultimately there isn’t an easy way for UiPath to recognise that these cells are struck out. Furthermore you have all the text in one cell rather than split out to make it easier to work with.
@sankar.kuna’s macro approach is your best bet if it works for data within the same cell but I wouldn’t be going near this for automation until the format of the data is setup in a more appropriate manner.
Macros will give Boolean output if the content in the cells are in single line(Is the case which you have done). where as @kuldip.gohil had multiple lines in 1 cell to which macro is not able to read them.
I completely agree. Input structure is the issue here.
There is a possible workaround, but its ugly…
Save the file as html and process it as a webpage - read tables inner html, split it by tr and td, then check class tags for formatting. Reading as dt will not work as it strips formatting.
But thats way more work than it should be. Best bet is work on input structure.
No. UiPath should not be changing their software to accommodate poorly designed processes. If they do this then eventually there will be a world full of these processes and UiPath’s brand name will suffer as a result.
There are far more important areas that UiPath should be focussing on.