Finding Differences Between Two Folders Of Excel Spreadsheet Files

Version 3.02 of DiffEngineX can now report on the differences between two folders of Excel workbook files (xlsx, xlsm, xlsb and xls) in one operation. The new functionality is available from the Compare Folders menu item under Tools.

The relevant section of the help file can be found here.

Compare folders of Excel workbook spreadsheet files xlsx xls xlsm xlsb

Exit Codes When Calling DiffEngineX Programmatically

DiffEngineX Exit Codes Command Prompt bat cmd file

DiffEngineX returns meaningful exit codes when called programmatically or from batch files. Only versions 2.22 and above return codes -5, -6 and -7. Only versions 3.02 and above return codes -8, -9, -101 and -102.

Exit CodeDescription
Positive Integer Number of worksheet cell differences
0 No worksheet cell differences found
-1 General Error
-2 Number of differences greater than maximum integer value
-3 Workbooks could not be compared due to protected worksheets
-4 Workbooks are different, at least, because of unpaired worksheet names
-5 Row or column alignment has failed
-6 Visual Basic difference report could not be displayed in a web browser
-7 Visual Basic difference report could not be output
-8 Error while comparing Excel defined names
-9 Error while comparing comments
-101 No worksheet cell differences found, but differences found in one or all of VBA, names or comments*
-102 Worksheet cells differences found and differences found in one or all of VBA, names and comments*

* The switches /comparevisualbasic, /compareexcelnames and /comparecomments must be specified if you wish to check for differences in VBA macros, defined names and comments.

In summary any positive integer, -4, -101 and -102 signify differences have been found in the Excel workbooks. 0 means no differences have been found. All the other codes signify errors or that checking for differences could not be completed.

A sample batch file (*.bat) testing the exit code is given below.

@echo off
del r.xlsx

"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX" /inbook1:"a.xlsx" /inbook2:"b.xlsx" /report:r.xlsx

@if "%ERRORLEVEL%" == "0" goto good

echo Workbooks are different or error occurred
echo return value = %ERRORLEVEL%
goto end

echo Workbooks have no cell differences
echo return value = %ERRORLEVEL%
goto end


Compare Excel Spreadsheet Files By Drag And Drop

Version 3.01 of DiffEngineX now supports the comparison of Microsoft Excel workbook files via drag and drop.

Simply drag and drop one or two Excel spreadsheet files on to any part of DiffEngineX's main user interface to load them, prior to clicking Start Comparison. If the desired workbook files are in open folders, this will be quicker than hitting the Browse button.

Any kind of file that Microsoft Excel can import is allowed, although the best results will be obtained with Excel workbook files (xls, xlsx, xlsm, xlsb).

Text Diff Tool For Microsoft Word & Excel 2013

A free 30-day trial of our tool to compare text in Microsoft Word and Excel 2013 is available from the Microsoft Store.

N.B. When comparing multiple Excel rows, as shown in the video, it is better to compare at the level of words than characters. It is primarily a text diff tool. DiffEngineX is our full featured Microsoft Excel compare software.


{besps_c}0|excel1.png|Excel 2013 App: Comparing Two Lists|{/besps_c}
{besps_c}0|excel2.png|Red and green for deletions and additions|{/besps_c}
{besps_c}0|excel3.png|Only showing the differences|{/besps_c}
{besps_c}0|word1.png|Word 2013 App: Comparing Text|{/besps_c}
{besps_c}0|word2.png|Blue and gray for moved up and down|{/besps_c}
{besps_c}0|word3.png|Just the changes|{/besps_c}
{besps_c}0|word4.png|Just the changes, but reordered lines omitted|{/besps_c}
{besps_c}0|word5.png|Choice of two panes or single pane for the differences|{/besps_c}

Review Of Dell Precision M3800 Windows 8 Laptop

We have written the vast majority of our software (DiffEngineX, Selection Diff Tool for Office 2013/365 and the diff text algorithm used on on Dell Dimension desktops and Inspiron laptops. As such we looked at Dell for our next generation of computers.

Earlier this year we purchased a Dell Precision M3800 15.6 inch laptop along with a USB docking station and an external DVD/CD reader/writer. The Precision line is thought of as being superior to other Dell models such as the Inspiron and Latitude. The M3800 has an aluminum top and a carbon fiber base. Unlike previous Precision models, the M3800 is thin and probably meant to compete with the MacBooks. At the time of our purchase, it was the only Precision model to come bundled, by default, with Microsoft Windows 8.1 rather than Windows 8. Its built-in display is a touchscreen with a QHD+ resolution of 3200 x 1880. It has 16Gb of RAM memory.

We were attracted to the Precision line as they have twin fans and dual drives. Our model came with a 256Gb solid state drive full mini card and a 512Gb 5400 rpm hard drive. A solid state drive (SSD) is the best way to speed up a computer. The responsiveness of the Precision compared to our earlier Dells is amazing. Our previous Dell Inspiron suffered from overheating when we left it working continually one day and so twin fans was a plus point for us. Just a few weeks after our purchase, Dell released a higher-spec Precision model with a 512Gb SSD.

The text rendering and display is superb, partly due to Windows 8. Its built-in monitor is excellent. Applications start up immediately. The secondary 5400 rpm hard drive is fast as well, probably due to it being a hybrid drive with in-built memory caching.

One thing to watch out for is that it has a Noble Security Slot, which I found was not compatible with Kensington laptop locks.

Overall we think it is a good purchase. The machine is fast, light and thin.


Minor Niggles:


Occasionally the display will blank out for a second, especially when right-clicking on the desktop.

For the specifications on offer, Dell is slightly more expensive than other manufacturers, but we did specifically want a laptop with twin fans and space for two drives. If you order through one of Dell's representatives it is sometimes possible to ask for a deal and get more than you would otherwise.

The laptop does not have an easy access battery hatch, so in case of a very bad operating system crash taking the battery out for a hard reset is not a ready option. We did learn however pressing the power button for something like ten seconds will perform a hard reset and get out of a bad operating system crash.




From our experience so far, we think this is a good purchase. The laptop has an excellent display, is fast, elegant and light. It is perfectly quiet in normal operation. Having a laptop with twin fans and both a SSD and a higher capacity magnetic hard drive were plus points for us.



Windows 8:


Dell do not produce Windows 8 and so any criticisms of it do not reflect on them. We have found that Microsoft Virtual PC (important for running legacy operating systems as a guest on your current one and hence testing) does not run on Windows 8, although it does run on Windows 7, Vista and Windows XP. There are alternatives, although, as software developers, we did find this annoying.

This is going outside the scope of the review, but Visual Studio 2012 and 2013 no longer include a Microsoft setup project, as they did in Visual Studio 2010. You can download the InstallShield Limited Edition for free, which pretty much covers most things the Microsoft setup project did. We managed to convert over our setup project in one morning. We were disappointed that the size of our installer increased from 44.4 Mb to 59.2 Mb, when Microsoft dot net 4 installation files are included. Some of the less vital parts of our setup project could not be converted over. We don't know whether this is because the InstallShield Limited Edition doesn't have the functionality or that we didn't look hard enough to find it.

If the transition to Windows 8 had been a little smoother, we would not feel the need to go back to Windows 7 occasionally.

Before our purchase of the Dell Precision, we did install Windows 8 on a Sony Vaio laptop we purchased in 2008. We were quite amazed at the speed up in boot up times as compared to Windows 7.

Most commentators on Windows 8 concentrate on the loss of the Start Button and its hierarchical list of applications. This ignores the performance boost of Windows 8 as clearly seen when we installed Windows 8 on old our Sony Vaio. It is quite possible to partially replace the lost functionality by moving application shortcuts to the taskbar. Right-clicking an application shortcut on the taskbar reveals the list of recent documents opened by it.