DiffEngineX is a fast utility that finds the differences between the formulae, constants, defined names, cell comments and Visual Basic code contained in either two whole Excel workbooks (*.xls, *.xlsx, *.xlsm, *.xlsb) 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.
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.
- Fast: Two 4Mb Excel spreadsheets can be compared in 30 seconds.
- Compares .xls, .xlsx, .xlsm and .xlsb files (all formats: Excel 2000, Excel 2003, Excel 2007/Excel 2010).
- The trial version is free to use.
- Compare formulae, constants, defined names & cell comments between workbooks or selected sheets.
- Compare Visual Basic for Applications (VBA) code / macros.
- 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 or percentage change.
- 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.
# Any version of Microsoft Excel(all versions from 2000 to 2010)
# .NET Framework 2.0
· 30 days trial