How do I get information in Excel and show it in a Message Box?

Help
, ,
3

Hi @Perawat,

This is quite similar to :
Compare two CSV files and write common column values accordingly - Build - UiPath Community Forum

In your case the input data is .xlsx, which is just a small modification.

  1. Read your data Excel Application Scope —> 2 Read Range —> Datatable1, Datatable2
  2. Use Join Datatable Inner join and specify the input datatables and where “ID” = “ID” (Check on keep rows)
  3. Then delete the ID_1 Column (this column header is created when an inner join is performed)
  4. The result should be what you are looking for.

Cheers!

1 Like