Forum Discussion

kandy1984's avatar
kandy1984
Contributor
10 years ago
Solved

Trouble comparing .xlsx file

Hi, I am using the code below to compare 2 .xlsx files. Sub Main     xlfile1 = "C:\Users\lac001\Desktop\aaa.xlsx"     xlfile2 = "C:\Users\lac001\Desktop\bbb.xlsx"     r...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    10 years ago
    Hi Sudha,

     


    I observe the same behavior on my computer. This sample was created by our TestComplete Customer Care Team. Could you please contact them to investigate what is going wrong?


     

kandy1984's avatar
kandy1984
Contributor
10 years ago
Hi,



I have got a solution from the TC team. 



It looks like there's a bug in the extension's code. Here's how you can fix it:

1. Rename the ExcelCompare.tcx file to ExcelCompare.zip.

2. Extract the archive to a local directory.

3. You will find 2 files there - Description.xml and Script.vbs

4. Open Script.vbs with any text editor.

5. Navigate to line 69 (If Abs(cf1-cf2) > 1 Then)

6. Modify the condition to make this line look like this:

If Abs(cf1-cf2) >= 1 Then

7. Pack the two files back into a zip archive, for example, ExcelCompare.zip.

8. Rename its extension to tcx and add the modified extension to TC.



Im not sure if those guys have fixed the code which is in the website now. But people who had already downloaded this extention can modify this to make it work.



Thanks.



Sudha