View Image

DiffEngineX is a utility that finds the differences between the formulae and constants contained in either two whole Excel workbooks or selected worksheets. It generates a cell-by-cell difference report in a new workbook and color highlights different cells in automatically made copies of your workbooks. As Excel spreadsheets get modified over time new rows and columns can be inserted between existing ones. DiffEngineX can align both similar rows and columns in the sheets being compared.

It has many powerful features such as the ability to hide matching rows, group like changes to adjacent cells and highlight differences at the character level. It can be used from its user interface or programmatically using command-line arguments.

By reporting the differences between original and modified Excel files, it has a role in version control and management.

Features:
* Fast: Two 4Mb Excel workbooks can be compared in 30 seconds.
* The trial version is free to use.
* Compare formulae & constants between workbooks or selected sheets.
* Alignment of rows and/or columns with similar content between sheets (minimizes spurious differences).
* Report can group like changes if they are made to adjacent cells (report lists 1 change to a range of cells). This is useful when the spreadsheet contains large blocks of equivalent formulae. Check the option "Compact like changes when contiguous".
* Choice of comparing formulae or their calculated values.
* Numeric values compared to a user specified number of decimal places. Useful for ignoring small fractional differences.
* Numeric differences can be ignored if less than a user specified amount.
* Difference report created in a new workbook.
* Powerful option to highlight precisely the parts of formulae and text constants that differ on the report e.g. =A1+Costs+6 and =A1+NewCosts+4.
* Option to add hyperlinks that connect the difference report (often titled Sheet1) to every cell found to differ between two spreadsheets.
* Color highlighting of differences, at the whole cell level, made to copies of your workbooks (separate colors for additions, deletions & modifications).
* Optional removal of existing workbook color before highlighting added (unconditional fill colour only).
* Can optionally hide matching rows enabling convenient discovery of widely separated differences (available on the Extras dialog).
* Can hide different rows enabling just the identical ones to be revealed.
* Can be run using command-line arguments or from its user interface.