Highlighting uncommon items in a datasheet

[PPIM_RPA]

Hello Forum,

I have uncommon rows populated from two different excel sheets.
Both uncommon items are displayed, to see what is different.
The customer would like for the second item in list to be highlighted to show the differences.
Any suggestions on how to do this utilizing Excel Classic?

Thank you so much

[Yoichi]

HI,

How about the following?

addresses = dt1.AsEnumerable.SelectMany(Function(r,i) r.ItemArray.Select(Function(o,j)  if(o.ToString=dt2.Rows(i)(j).ToString,"",UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(j+columnOffset)+(i+rowOffset).ToString))).Where(Function(s) not String.IsNullOrEmpty(s)).ToArray

Sample20230324-2L.zip (9.5 KB)

Regards,

[PPIM_RPA]

Thank you for your suggestion. I’m getting message: RPC server is unavailable. The uncommon rows are already gathered and sorted. Just need them highlighted.

[Yoichi]

HI,

Which activity throws the exception?
Can you try to put Kill activity for excel at the beginning of the workflow as the following?

Regards,

[PPIM_RPA]

Thanks for your advice. It might make sense to see what I am attempting. However, you will probably see lots of mistakes. Just trying to highlight the second row as above after everything
Excel Uncommon Rows.zip (750.4 KB)

[Yoichi]

HI,

It’s necessary to compare record which has same Contract #. Is this correct? ( This also means Contract # is always unique in each sheet)
And my understanding is if there is different b/w both record which have same Contract#, output it to other sheet and highlight cell which has different value, right?

Regards,

[devik (Devi Kandasamy)]

Hi @PPIM_RPA Can you try this way. Attaching the code as well. Hope it helps.
Main.zip (3.9 KB)

[Yoichi]

HI,

Can you try the following sample? This output result.xlsx which has 2 sheets result1 and result2 which has colored cell if value is different.

Sample20230324-4L.zip (748.7 KB)

Regards,

[PPIM_RPA]

Correct. Thank you for looking

[PPIM_RPA]

Thank you so much for your time in looking this over.
Exactly what I was looking for.
Appreciate it.

[PPIM_RPA]

Would like to autofit Columns on appended sheet but haven’t figured out how to do that on Excel Classic yet with this workflow. Can do it manually in a few shortcuts but still holding out hope this too can be automated on Classic version of Excel