Compare Excel files

With the Excel Engine 3.0, you can compare the cell contents, cell formatting, and objects of two Excel files.

To do so, use the Module TBox Excel 1:1 File Compare.

The Module is part of the Standard subset. You can find it under Standard modules->TBox XEngines->Excel.

In this example, you compare the Excel files reference.xlsx and target.xlsx. Both files are located at C:\Temp. You perform the following steps:

  • You specify the required password for each file.

  • You specify that you want to compare only the cell contents of Sheet1 and Sheet2.

  • You specify that Tricentis Tosca should save the result to C:\Temp\report\results.txt.

Compare two Excel files