Florencesoft
News: Version 2.14 has options to compare Excel defined names, cell comments and VBA code/macros. Hyperlink navigation from the difference report straight to differing cells.
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 08, 2010, 11:53:43 PM


Login with username, password and session length


Pages: [1] 2 3
 1 
 on: August 17, 2010, 04:56:03 AM 
Started by Admin - Last post by Admin
Although DiffEngineX is not currently exposed as a COM component or DLL class library, it is possible to invoke DiffEngineX programmatically from software, as well as from the Windows Command Prompt. DiffEngineX can be driven by command line arguments. A full list of arguments is given in the help file available from the DiffEngineX menu item Help-->Help Topics-->Command Line Arguments. The list is also available at http://www.florencesoft.com/xldiffhelp.html#commandlineargs.

A snippet of C# .NET source code showing how to do this is given below. (The /outbook1 and /outbook2 arguments are optional, if you don't want to save the DiffEngineX created reports to your filesystem. As /show has been used, the /report argument is also optional in the example below.)

Code:
using System.Diagnostics;

namespace CallDiffEngineXExample
{
private void CallDiffEngineXProgrammatically1()
{
Process process = new Process();
try
{
string filename = @"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX.exe";
process.StartInfo.FileName = filename;
process.StartInfo.UseShellExecute = true;
process.StartInfo.Arguments = @"/inbook1:""C:\Users\Bob\test worksheets\original.xlsx"" /inbook2:""C:\Users\Bob\test worksheets\modified.xlsx"" /report:report1.xlsx /outbook1:outbook1.xlsx /outbook2:outbook2.xlsx /compareexcelnames /coloralternaterows /addhyperlinks /colordifferences /show";
process.Start();
process.WaitForExit();
}
catch
{

}
finally
{
process.Close();
}
}
}

 2 
 on: June 29, 2010, 01:40:08 PM 
Started by Admin - Last post by Admin
Version 2.14 of DiffEngineX can compare the Visual Basic for Applications (VBA) code and macros contained in Microsoft Excel spreadsheets. The new difference report is in HTML format and is viewed in your default web browser.


 3 
 on: April 19, 2010, 09:03:46 PM 
Started by Admin - Last post by Admin
Version 2.01 of DiffEngineX allows you to specify a minimum percentage change between two numbers before they are flagged as different.

 4 
 on: February 17, 2010, 08:07:11 AM 
Started by Admin - Last post by Admin
We have recently written a concise description of DiffEngineX and guide to its use. It is recommended reading for everyone who uses the software. It can be found at

http://www.florencesoft.com/diffenginex-guide.html

 5 
 on: February 12, 2010, 08:02:50 PM 
Started by Admin - Last post by Admin
DiffEngineX can now compare Excel cell comments. This new functionality has to be explicitly turned on via the Options dialog. The comment differences are listed in a new sheet, called Excel Comments Comparison, on the difference report.

If a workbook of interest is compared against a blank spreadsheet, this option will effectively create a list of all the comments.

 6 
 on: January 03, 2010, 08:45:10 PM 
Started by Admin - Last post by Admin
DiffEngineX can now treat numeric values as equal if they differ less than a specified value. This adds to its previous ability of being able to round numbers to a specified number of decimal places before comparing them.

NOTE: If you wish to compare the calculated values of formulae, rather than the formulae text itself, you should select the option Their Calculated Values.

 7 
 on: November 10, 2009, 05:30:33 PM 
Started by Graham - Last post by Admin
SUMMARY: Turn off "Use Alignment Plus" on user interface and use /alignmentplus:false on command-line

The insertion of blank rows fails for sheet Internals, because that sheet contains Excel arrays and unfortunately Excel complains if it thinks you are trying to alter part of an array.

As a workaround I recommend you try row alignment again but this time specify on the command line

/alignmentplus:false

When alignmentplus is turned off, typically less blank rows need to be inserted and as such the problem with arrays is avoided. Alignment Plus is only need if you are comparing rows of data. For formulae based spreadsheets like the ones you are using, Alignment Plus is not needed. In fact for your case it adds problems when arrays are present.

If using the user interface, simply uncheck "Use Alignment Plus (recommended)".

We are currently looking at the other problem you mention with saving off .xlsm files. However at this stage we can say that you don't need to specify either /outbook1 or /outbook2. As you indicated to us in your email that you are using /show as well, it does seem that /outbook1 and /outbook2 really don't need to be specified.

As a workaround if you specify /outbook1:file1.xlsx and /outbook2:file2.xlsx instead of .xlsm then hitting "Yes" twice when the Excel dialog boxes are displayed will correctly save the files.

Our revised command is shown below:

"C:\Program Files\Florencesoft\DiffEngineX\DiffEngineX.exe" /inbook1:"myworkbook1.xlsm" /inbook2:"myworkbook2.xlsm" /outbook1:"colorhighlighted1.xlsx" /outbook2:"colorhighlighted2.xlsx" /alignrows:"A,B,C" /colordifferences /removeexistingcolor /unhidesheetsrowscols /compactchanges /coloralternaterows /colorpreciseondiffreport /colorpreciseonworkbooks /compareexcelnames /addhyperlinks /caseinsensitive /report:"mydifferencereport.xlsx" /alignmentplus:false

 8 
 on: November 10, 2009, 03:25:32 PM 
Started by Graham - Last post by Graham
I'm just using the evaluation version of DiffEngineX and I like it, but have encountered an issue with .xlsm files.

I've set up a little script to use DiffEngineX as the diff tool for file extensions .xls, .xlsx, .xlsm, .xlsb in TortoiseSVN, using the command line interface to DiffEngineX.

However, when I use /outbook1:file1.xlsm /outbook2:file2.xlsm (/inbook1 and /inbook2 are .xlsm files), along with /colordifferences and /alignrows, I get two Excel error dialogs, which state:

"The following features cannot be saved in macro-free workbooks:
     * VB project
..."

In each dialog I'm offered a choice as to whether I want to save the file as a macro-free workbook, or choose a different, macro-enabled, file extension under which to save it. Neither choice seems to have any effect.

Finally, I get a DiffEngineX error dialog, which states:

"Insertion of blank row/rows failed for sheet Internals"

When Excel opens (I've chosen /show as a command line parameter in addition to /report:somefilename.xlsx), I get three Excel files, the difference report "somefilename.xlsx", and the two temporary, colour-coded, row-inserted workbooks that would show if I had not used /outbook1 and /outbook2 parameters. In the Comparison Summary sheet of the difference report, I'm told that "Error: Internals could not be correctly aligned."

How do I handle .xlsm files correctly without errors? I have some complex workbooks with VBA saved as .xlsm. Obviously I'm not expecting DiffEngineX to compare the VBA, I just want a correct comparison of the corresponding sheets of the two workbooks.

 9 
 on: September 29, 2009, 02:05:54 PM 
Started by Admin - Last post by Admin
Add Hyperlinks To Aid Navigation has been added to the Options dialog. This connects the difference report to every cell found to differ between two spreadsheets. Please refer to the http://www.florencesoft.com/xldiffhelp.html#hyperlinksoption for details.


 10 
 on: September 18, 2009, 09:56:31 AM 
Started by Karl-Anton - Last post by Admin
Updates are free for up to 1 year after your original purchase.

Version 1.41 has a new menu item called Check for Updates available from the Help menu. It will tell you what has changed in later versions and offer you the choice of automatically updating itself.

Pages: [1] 2 3
Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM