Forum Discussion

kandy1984's avatar
kandy1984
Contributor
12 years ago

how to compare .xlsx files using file checkpoint?

Hi,



I have 2 .xlsx files that i need to compare the contents. How can i do this using a simple script? I hope some one can help  as i am very new to TC.



Thanks.

1 Reply

  • kandy1984's avatar
    kandy1984
    Contributor
    12 years ago
    Hi,



    I found out the way using the code below.





    Sub Main




        xlfile1 = "<Path_To_the_1st_File>"




        xlfile2 = "<Path_To_the_2nd_File>"




        resfile = "<Path_To_the_Result_File>"




        Log.Message objectExcel.ExcelCompare(xlfile1, xlfile2, resfile)




    End Sub