Creating script to compare excel files

[Dumi1]

Hi Guys

Please help me create a script to compare products from an excel sheet to an excel output sheet

For an example :

           You run a product and when its done you have to compare with the spec that you have if all fields or products were run in that ouput. So far we currently doing it manually. We look at the file and check the spec and it it off one by one. There should be a way I can run a script right?

[Kurt_Bremser · Accepted solution]

It's easy to compare datasets, and that is where you should do your tests. What Excel does with the data is some kind of elaborate lottery, after all. And WILL change with the next Excel version.

[Dumi1]

thanks Kurt, let me play around with it