Forum Discussion

kandy1984's avatar
kandy1984
Contributor
10 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.
kandy1984's avatar
kandy1984
Contributor
10 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