Which programming language will be easy to develop a script or code for comparing two excel files?

Question

I want to develop a code for comparing two excel files and to find if there is any difference between the two files . Pls suggest using which programming language it will be easier!! I personally think Python is. Do we have any language easier than python for developing the code for comparing 2 excel files?

Answer 1

Python is best

Answer 2

You are right python is the best

Answer 3

It depends what you are comparing - excel has VBA included which is very powerful.

There is also a python extension for excel so you can run python within excel.

It's also very easy to convert excel files to csv with python. I think it can be done in two lines.