DiffEngineX is a desktop software application that reports on the differences between two Microsoft Excel workbooks. It not only compares the spreadsheet cells, but also the Excel defined names, comments and embedded VBA (Visual Basic for Applications) macros. You have a choice between comparing formulae or their calculated values.
DiffEngineX generates three reports. One is a cell-by-cell listing of workbook differences. The other two are color highlighted copies of the two spreadsheets you are comparing. Color is used to highlight differences. There is an option to hide matching rows on the color highlighted copies, leaving just the differing rows behind. This allows you to easily and quickly see all the differences highlighted in color without having to scroll through large numbers of identical rows. Note: DiffEngineX never modifies your workbooks – it creates copies and colors those instead.
Often new rows and columns are inserted in a spreadsheet. This can confuse a straightforward difference analysis. DiffEngineX can align similar rows and columns between Excel workbooks. DiffEngineX can compare database data imported into Excel, on the proviso that the rows are in sorted order. Excel has functionality under its Data tab to sort rows.
DiffEngineX has several options to ignore small numeric values and whitespace.
It is fast, well-tested and scalable software with a large user-base grown over many years.
It can be invoked without its user interface using command line arguments. It can be automated from .bat, .cmd files and the Windows Command Prompt. If your software development environment supports invoking .exes as external processes and supplying command line arguments, DiffEngineX can be called from software
Results of comparing two Microsoft Excel workbooks
Compare Excel Workbooks 
Leave a comment