Forum Discussion

Ivett_K's avatar
Ivett_K
Occasional Contributor
6 years ago

How to compare two Excel workbook's cell values

Hi,   We are trying to compare two Excel workbooks by specifying which cells should be compared as the column orders don't match in the files. We aren't a very technical team and tried to run the c...
sonya_m's avatar
sonya_m
Icon for Alumni rankAlumni
6 years ago

Thank you for helping tristaanogre

 

Ivett_K , did you manage to solve this issue?

If you update to the latest TestComplete version (14.50), you can try using the new Excel support to implement this task. It does not even require Excel to be installed on the machine.

Ivett_K's avatar
Ivett_K
Occasional Contributor
6 years ago

Hi Sonya,

 

Thank you for your message.

 

We decided the leave comparing excel files for now as we did further analysis and came to the conclusion it would be far too complicated as the formatting is is completely different in the files we wanted to compare.

 

Thanks,

 

Ivett