Compare Excel Table with different File Type (.xlsx) and (.xls)

datatable
excel

#1

Hi all.

I want to filter and compare two data tables in different excel files, then merge them. I have two Excel Files.

  • The first file (NumberOfReference.xlsx)
  • The second file (StatusAndReference.xls)

I want to use Read Range Activity from UiPath to find a match between these two Excel Files. Read Range can read .xlsx. However, When I use Read Range, it can only read the first excel file. Not the second file as it is in .xls

The workaround that I tried :

  • Use Read Range and Write Range. But, Write Range will work if .xls files already exist. In my case, UiPath cannot find .xls

The primary objective here is that I want to compare this two Excel File and find a match of a number if it exists. I am unable to do so because of Excel different file type.

Appreciate if any of you could help me.
Thanks in advance.

Regards,
Loshyy


#2

For .xls files, Microsoft Office (i.e. Excel) must be installed. That’s not required for .xlsx files.

Hope that helps.


#3

Hi @tmays . Thanks for your reply.:grinning:

I do have Microsoft Office on my machine.

As you can see, I have Microsoft Excel 2016 installed.

Do you have any idea how can I compare these two files and find a match in UiPath?
Any help would be appreciated.

Thanks.

Regards,
Loshyy


#4

Do you have visible flag checked while opening the xls ??

try this to see if the xls is read in visible mode …


#5

Hi @sai.kiran

Thanks for your reply. Yes, I do have it. So, when I put visible flag checked and unchecked, I receive the same error.

Please find below:

The goal is here is to compare 2 excel file, 1 is .xlsx and another one is .xls and then to find a match between them. So far, this is what I did:

Appreciate if you have any other solution to solve this issue.

Thanks.

Best,
Mutiah


#6

Hi @Loshyy_Mahad,

use the Read Range and Write range inside the Excel application scope.

Regards,
Arivu


#7

As @arivu96 said ,

Double click and open the excel application scope activity , and put read range and write range inside it … it should work.

if not , upload your workflow here with sample excel files … we will take a look at it